Forum Discussion

uthall's avatar
uthall
Helper 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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

This will work for all. 

 

https://youtu.be/UyJieY69_sE

 

* STEP1 : Row headers > Options > Stepped Layout (Turn this on!)

* STEP2 : Row subtotals > click 'ON' > Apply setting to 'Per row level' then select the first row

* STEP3 :  Row headers > Options > Stepped Layout (Turn this off!)

 

Jeanxyz's avatar
Jeanxyz
Power Participant
3 years ago

It doesn't work on my report. No. 1, the layout of Row subtotals are different now, I can only select one row level, No. 2, it shows me two subtotals, one is the grand total on top, the other is subtotal by project ID. I have not chosen project ID in my Subtotal by Project ID, and project ID is my lowest reporting level. I'm not sure why it's showing subtotal on project ID here. 

 

Is this a bug?