Show only grand total in matrix

[JohnS1968]

Hi all,

Is there some way of hiding all values (subtotals and individual category values) from a column leaving just the grand total in the bottom?

What I mean is that I have this:                   

   

And I need it to show up like this:

The pink fields are subtotals for each country/group of categories.

Cheers,

J.

[PaulDBrown · Accepted solution]

Here is one way:

Assuming:

Group of categories field = Table A[Group of categories]

Country field = Table B [Countries]

Variance measure = [Variance]

Use a measure along the lines of

Only totals =
SWITCH (
    TRUE (),
    ISINSCOPE ( 'Table A'[Group of categories] ), BLANK (),
    ISINSCOPE ( 'Table B'[Countries] ), BLANK (),
    [Variance]
)

[JohnS1968]

Worked as a charm, thanks 🙂

[mahoneypat]

Please check out the Row Subtotals options in the visual. You can select which fields to show subtotals for. In this case, I have it turned off for Product but on for Category.

Pat

[amitchandak]

@JohnS1968 , Under the row subtotal, Remove all subtotal, other than the first level.