Forum Discussion
Add Total row for table (column is not summarized)
Hi I have a number column in Table report. I don't need to Sum() this column (marked as "Don't summarize"), but I still want to see Total sum for this column. I have several lines for each d...
Thanks, Charlie
Regarding "why" - again, I mentioned it in my question (with some figure corrections):
>> For example I have lines with 3, 5 & -8 for today. If I mark the column as "Sum" - I'll have just one line with 0.
>> But I need to see all three lines and have Report Total at the same time.
Currently as a workaround I've added a line ID field to report and made the column as narrow as possible (so it's almost invisible) but I don't like this solution.
For the ID field, you can right click on the ID column in the table view and mark "Hide in report view" --> This will not show in the report view.