Forum Discussion

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
3 years ago
Solved

Subtotal vs Grandtotal formatting

Have a look at this matrix:

The subtotal row for 2022 giving the same info as the grandtotal.

How could I fix this. Seems only on subtotals there is an on/off switch.

If I switch that off I lose the subtotal AND the grandtotal 🙄

 

What setting would give me only grandtotal, or only subtotal.

In this case not minding much. One time a total in the view is enough.

  • Hi

    In Edit "Subtotal", open "Per row level"

    Turn off your "YEAR", but keep on your sub-cat. It will not show row of Grand Total.

2 Replies

  • HoangHugo's avatar
    HoangHugo
    Icon for Solution Specialist rankSolution Specialist

    Hi

    In Edit "Subtotal", open "Per row level"

    Turn off your "YEAR", but keep on your sub-cat. It will not show row of Grand Total.

    • rpinxt's avatar
      rpinxt
      Icon for Solution Sage rankSolution Sage

      Ah superb HoangHugo 

      Bit hidden this option and not very straight forward.

      Indeed if I switch off Year it will remove the grand total and if I switch off the other one it will keep grand total and remove the subtotal.

      So I can even choose what I like best 😁.

      Thanks!