Forum Discussion

uthall's avatar
uthall
Icon for Helper II rankHelper II
9 years ago
Solved

Grand Total Only

Hello,   I would like a matrix to show the grand total only, and not the subtotals..   There doesnt seem to be any option for this very basic requirement.   Am i missing something?
Need Help
  • tringuyenminh92's avatar
    tringuyenminh92
    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.

tjd's avatar
tjd
Icon for Impactful Individual rankImpactful Individual
9 years ago

I have been working on the same type of problem and it seems to me that you're only going to get the solution you are looking for (right now) by either using only one category.  Seems to me that if you use more than one category in a matrix, you can only get each category's row and sub-row totals which is what you don't want.  I had to switch my visual to a table (from a matrix) in order to get the view you show; but then you lose the nice category formating of the matrix (:.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

You can't selectively turn off subtotals in the matrix visual. You either get subtotals for everything, or no totals at all. Those are your only options. For some reason they left this basic feature out. The best workaround I've found is to write a measure that produces some of the items you would use for the non-subtotaling columns, and use that in the values.