Matrix show row grand total only

[TomSinAA]

Trying to figure out how to display row grand total only in a matrix visual that has three fields per row. Below screen shot shows subtotals for Week Start and LJ Department and Site.  Is there a way to not display those subtotals and only display last row (i.e. Grand total)?  There is a setting to turn Row Subtotals on or off.  But there isn't a similar setting to turn on Row Grand Totals on or off

[v-xinruzhu-msft]

Hi @TomSinAA 

Did the solution @Ritaf1983  provided hepl you solve the problem? if it helps, please consider to mark it as a solution, or you can offer more information.

Best Regards!

Yolo Zhu

[Ritaf1983 · Accepted solution]

Hi @TomSinAA 
To have a grand total on and row subtotals off you need to switch off the row sub-totals of all hierarchies except of the highest.
For example, my matrix has 2 levels :
Category and age group :

So on age group, I'll switch off the row subtotal:

and on category switch on :

Result :

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.