How to create cross tab report like Pivot table
Hi,
I want to create cross tab report like Pivot table but without using Pivot app. Please suggest how to do that. I want to show 1 column in the left and other column on the top with sum or count of values. I tried to use Report but in Report it comes in vertical report and not like cross tab format.
Please suggest on how to do
Answers
-
What data is it that you're looking to collect? You could use a COUNTIFS or SUMIFS function to create your calculations and use cross-sheet references to look into your source sheet, returning a value based on what's in your column to the left.
If you need help with the formulas, it would be useful to see a screen capture of your source sheet and an explanation of your end-goal, but please block out sensitive data.
Thanks!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives