Pivot Table using Sheet Summary Report
Hello,
I need to create a Pivot using a Sheet summary report as the only source file. When I go to the pivot builder I do select my report as a source, but once I move to "Assign Columns" I am not able to select any row / column / Value to populate the Pivot: if i click on "Add Field" it always shows "Empty" (which is not the case as my Sheet Summary Report has several columns).
Is this problem related to the type of report not supported by the Pivot app? If so, when will this be solved? Right now I am forced to copy/paste my report on a blank sheet to generate the pivot, which is not very efficient.
Thanks a lot for the help!
Answers
-
Hi @Viola Rurgo
You are correct, currently this type of Report (a Sheet Summary Report) is not able to be used by any of the Premium Applications, such as Pivot (see the "note" under "Before You Begin" on this page, here: Sheet Summary Reports).
Please let our Product Team know about your feedback by filling in this form, here.
As an alternative, could you create a Metrics Sheet with formulas generating your data into a sheet's cells, instead of using the Sheet Summary feature?
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 286 Events
- 37 Webinars
- 7.3K Forum Archives