Summarizing a Report
I have recently started working with Reports and like the summary functions but whenever I add a summary, I get a TOTAL line at the top of the report and there are times I DO NOT want a total.
For example, I am creating a Financial Statement Report that has approximately 100 lines which I can summarize into "Sales", "COGS", "Operating Expenses", etc.
The report works great except I get a "TOTAL" at the top that simply sums every line of detail on the report, which frankly, makes no sense. And I can't seem to figure out how to get rid of this annoying line of summary that I don't really want...
Any help is MUCH appreciated. Partial Screen shot below to show the First Line that I do not want...
Best Answer
-
There is no way to get rid of that summary line when using grouping/summary functions within a report.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
There is no way to get rid of that summary line when using grouping/summary functions within a report.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
That's what I was afraid of... This would be Perfect were it not for that useless line of unwanted information..
Oh Well... Looks like I'll have to do two reports, a Summary and a Detail.
Thanks Paul! Appreciate the fast and honest answer.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives