How can we get subtotals with Grand Totals and grand "subtotals" in a matrix

[tfgardner]

We have a need to show subtotals and a grand total - but also a grand total of each of the subtotal rows.  For example we have a series of cities and then a break out of hours worked Reg and OT under each city.  We are only getting a Grand total of all the hours but we also need to see a total of all the Reg and then another total of all the OT.  This is easy in a pivot table or SSRS.  Is this just a limitation of PowerBI matrix?

[v-lili6-msft · Accepted solution]

hi, @tfgardner 

If the Reg and OT are the value of one filed. If so, just use drill mode in matrix visual

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

If they are different fileds, you could do unpivot columns in Edit Queries.

In edit queries, select Reg and OT, then unpivot them and use drill mode in matrix visual.

Best Regards,

Lin