Forum Discussion
Grand Total Only
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.
I realise I am a bit late to the party on this discussion, but I recently needed to do something very like this, and found a different way to accomplish it.
My need was also to have multiple columns display the total - with several different measures etc. this meant I really needed to find a way for the matrix to provide this.
My approach was to make a 2nd copy of the matrix, then turn subtotals on, but to narrow the height of the matrix until ONLY the header and the Grand Totals row were displaying. This then meant I could place things where I needed to, display the grand totals, AND NOT the subtotals.
I did place the first matrix on top (in front) of the header row on my second matrix - which allowed a bit of ugly text leakage. This I fixed by placing a white box strategically in front of my 2nd matrix to hide the header row - but behind the 1st matrix.
I did this too, but it's a really frustrating fix for someting that BI should do with a setting. I hope they fix this eventually.