Subtotals does not show in row headers

[NickProp28]

Dear Community, 

I go thru all the setting in format field and there's no where I can show the subtotal in rows header.

I want to show the total weekly target ('=90') for my customer. 

Here is my fields,

Attached with the pbix : https://drive.google.com/file/d/1YKyJr8M7Zbz15hlT6iSo-fJk6zABfgFR/view?usp=sharing
Thanks for your attention and appreciate any helps provided.

[Anonymous]

Hi @NickProp28,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.

If that also doesn't help, please share more detailed information to help us clarify your requirement to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Shen

[Anonymous · Accepted solution]

HI @NickProp28,

AFAIK, matrix aggregate features only work on the value fields. They do not summary the category fields(row/column) values. If you also want to summary these values, you can move the category field to value fields.
Regards,

Xiaoxin Sheng

[amitchandak]

@NickProp28 , I do not think power bi shows Grand total for rows and column (pivot columns)

You can log an idea