Matrix Visual - Column totals at Drill down level, not drill up level.

[shaunwilks]

 Column totals at Drill down level, not drill up level.

I have a matrix where the Quarters are my columns at the highest level. While up at this level I would like to see a TOTAL for the Year, and therefore turn on "Column Subtotals". This works well when I am this level.

I then drill down into the lowest level where Q1-Q4 are shown and the months Jan-Dec under it.

The Year grand total still shows which is gret but I have a SubTotal by Quarter - which is not what I want.

I want to just have the 12 months across the page with the Year total at the end in the last column.

But to turn off the Subtotals at this level is to turn off the Grant Total column at this level also.

Why can I just have a Grand Total column show in the matrix ?

If not possible does anyone know of custom visuals that may achieve this.

[shaunwilks · Accepted solution]

I was able to resolve this after finding the "Per Column" option within subtotals.

The new interface made it not the easiest to find but was then able to disable Subtotals are different column levels.

I had perviously only seen the "Per Row" option within the subtotals.