Reports : Missing title on column in report

Hello,
I currently have a messy report with four sheets that I wanted to clean up. I noticed the information was being separated due to slight differences in the titles. So, I went through all four sheets and made sure the titles were exactly the same, then I created a NEW report.
This is from the messy report. I not sure how these sub categories were added (boss created report)
But now after I created a NEW report I don't see, Primary Column as an option in the Columns or J-1 Visitor Name
I just noticed that the first Column is labeled as Primary Column in the messy sheet and the new sheet is just Primary? I didn't title that
Also, I randomly checked the Filter Criteria in the NEW sheet and J-1 Visitor Name is there, but doesn't appear in the columns tab. There are no subcategories in the new report either.
Answers
-
Hi @SDSU
When you create a new report, the Primary column from your source is auto added and is named always as just Primary. You can double click on it and change it to any value, in this case, as J-1 Visitor Name as that is the primary column in your source sheets.
Thanks,
Aravind GP| Delivery Manager
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
But why isn't J-1 Visitor Name title on my columns list in the New Sheet? It's on the old one, I just have J-1 Visitor Email. I changed the primary title to J-1 Visitor Name but I am still missing the information.
-
AHH I figured it out! In one of the 4 sheets I had hidden the primary column because it was a title duplicate. I now rename the primary and added the contents from the other duplicate and deleted that one. Now they appear in the primary column in both reports. Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 505 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives