Row sub total Matrix without stepped layout

[Albertosaravall]

Hello,

I have a matrix with different categories at rows level, season at column level (FW22 and FW23) and sold units as value. (I have disabled the stepped layout and expanded all down level of the hierarchy). The aim of this matrix is to be as similiar as possible to an excel pivot. 

Actually I have totals on the right but I want to have them also below as showed before in red:

is it something feasible? because if I enable the row subtotals the matrix is a mess. ( i have subtotals also for the categories).

Thank you,

Have a good day,

Alberto

[rdannayak1]

Hi @amitchandak I tried using the option but for some reason i see the "Total" in all row levels, the version i use is "2.112.1161.0" is there some issue in my version of Power BI ?? tried working to show the totals in one level but nothing worked so far and i dont know why the per row level is not working, Any help here is appreiciated
Thanks,

Rahul

[Albertosaravall]

Thanks so much mate!! @amitchandak 

[amitchandak · Accepted solution]

@Albertosaravall , There is an option to control the what subtotal to show, using"per" option

Select each level and disable or enable