Forum Discussion

Albertosaravall's avatar
Albertosaravall
Frequent Visitor
3 years ago
Solved

Row sub total Matrix without stepped layout

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

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

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

     

     

     

    Select each level and disable or enable

     

  • rdannayak1's avatar
    rdannayak1
    Regular Visitor
    3 years ago

    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