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.
Answers
-
There is no way to get rid of that summary line when using grouping/summary functions within a report.
-
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
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives