Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to customize row total for matrix table

Hi,

           I have report with matrix table...Data source used in report is 

Current view of report is

I want to change total row of a matrix table to like this...

.

Is it possible to customize row totals to Combined rows with subcategory wise value total calculation ....

 

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , At Visualization property -> Under Sub Total, -> Per row Level -> Choose columns you want to have subtotal

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

    You need to create a new table and use it to create matrix visual.

     

    Best Regards,

    Caiyun Zheng