Forum Discussion
Grand Total Only
- 9 years ago
Yeah, Agree with Anonymous, uthall you should let matrix show details and turn off total row,column. and then show Grand total in Card next to matrix.
Doesn't work for me quite as Belinda describes. Not all options described from around 3:50 in the video are available to me. This is surprising as I think I have a more recent version of PBi than the one shown (I have the paintbrush formatting icon as opposed to the roller one). I have Stepped Layout and Row sub-totals on with the "Apply settings to" and "Per Row Level" also on. The choices to turn sub-totals on for specific categories are there, though the presentation is more compact and less friendly. But, the sub-total labels aren't editable, everything is just "Total" you can't name them individually as Belinda does. Nevertheless, yes, it is possible to keep an overall "Grand Total" and turn other subtitles off which is what was bothering me when I first posted here. It's still a little odd that what you can format as the "Grand Total" is also just the top level of the sub-totals. Although I can see that makes sense as that is what a Grand Total is, why not have the top-level of sub-totals labelled, in brackets, as the Grand Total. Also why isn't the Grand Total "on"/"off" setting in the "Grand Total" section, it could overide anything in the "sub-totals" section so that the grand total is "on" (i.e. it would turn on sub-totalling for the top row level of the visualisation).