Power Bi Matrix: layout with categorical values and their subtotals

[lorentz]

Hello everyone,

Is there a way to obtain the following layout

that is, putting together categorical values (A, B, C etc) and their related columns subtotals in the same matrix?

put categorical values is possible (in matrix values, with First or last aggregation), but how can i achive the subtotals column?

i attach the sample table

Region	City	Week	Month	Letter
Region 1	City 1	Week 1	Month 1	B
Region 1	City 1	Week 2	Month 1	A
Region 1	City 1	Week 3	Month 1	A
Region 1	City 1	Week 4	Month 1
Region 1	City 1	Week 1	Month 2
Region 1	City 2	Week 1	Month 1
Region 1	City 2	Week 2	Month 1	E
Region 1	City 2	Week 3	Month 1	C
Region 1	City 2	Week 4	Month 1	E
Region 1	City 2	Week 1	Month 2
Region 2	City 3	Week 1	Month 1
Region 2	City 3	Week 2	Month 1	D
Region 2	City 3	Week 3	Month 1
Region 2	City 3	Week 4	Month 1
Region 2	City 3	Week 1	Month 2	B

Thanks a lot.

[parry2k]

@lorentz you cannot achieve it in the same matrix, it has to be two different visuals.