Matrix / Table report with subtotal

[Anonymous]

i have to develop a report with below format .is a possible to develop the below format in matrix as same as it . 

usually matrix gives as a  drill down . but i need some of the grouping values as column and need to caluculate subtotal 

based on the different categoried by grouping it .

is it possible to create sub total in table visual . Please help . appreaciate any suggestions. 

[v-shex-msft]

Hi @Anonymous,

You can also take a look at the following blog about custom subtotal and handles of these calculations:

Insert Custom Subtotals in the Matrix Visual 

Regards,

Xiaoxin Sheng

[themistoklis]

@Anonymous 

Yes you can actually do that in a matrix.

If you want the drill down information to be displayed in separate columns please do the following.

Add a matrix visual and then on format section go to Row Headers --> Stepped Layout should be OFF

For Subtotals go to Format --> Subtotals and Turn ON or OFF the Row Subtotals or Column Subtotals

You can also specify the Row Subtotal Position (Top or Bottom)

________________________

If this post helps, then please Accept it as the solution to help other community members find it more quickly

Click on the Thumbs-Up icon if you like this reply.

Check out my COVID-19 Report in Data Stories Gallery:    COVID-19 Report