When selecting multiple dimensions in the grid view, is there any way to print a report with subtotals for each level? I see that you cannot do this in the nested view either. This is a basic reporting function so I hope I’m just missing it somehow…
You can’t select more than one dimension in the grid view, this is only possible in the nested view.
However, as you say it doesn’t retain the subtotals when you expand the selection. I’m told this was a decision Phocas had to make when developing the grid format. There is a Product Suggestion logged and @will.marriott said they’d canvas opinion on it. I also raised it with @Tim.Leonard at the recent PUG and stressed how important I felt it was for Phocas to think a little outside of analysis and embrace general reporting.
You could consider using the Nested Table function in Dashboards as this does allow you to have sub-reports within in dimension, up to three layers deep. The formatting isn’t quite as intuitive as the grid function but it does give you dimension level sub-totals.
Link to Product Suggestion - Keep Subtotals on Nested Tables
1 Like