How do I create a report that is a pivot of duplicate items, with a status?
Hello! I have a tracker that consists of multiple contacts per client resulting in duplicate names for a single client, however, a single "status" column that covers the client. I am trying to pivot the client and status however, am struggling to figure this out. I would like to create a report by status that I can then create a dashboard for overall project status, along with a list of client, by status. Thanks in advance for your help!
Answers
-
Hi @TeriB
It does sound like a Report should work for your purposes! You'll want to Group the Report by either the Status or Client (or both, depending on what you want to see).
Here's a webinar that goes through Grouping and Summary in Reports: Redesigned Reports with Grouping and Summary Functions
If you're still unable to create the view you need, it would be helpful to see a screen capture of your source sheet (blocking out sensitive data) or source sheet set-up with test data.
Thanks!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!