Show Subtotal in Table

[BishwaR]

I am using a table in the report ( not Matrix) there are products  and count columns

Product  Coumt

A             2

A             3

A             4

B             1

B             2

C            3

C            1

C            1

Is there any way I can show the sub total of each product at the end the each product row ?

Thanks Bishwa

[selimovd · Accepted solution]

Hey @BishwaR ,

sadly there is no subtotal for a table visual. The subtotal exists only for the matrix visual.

Would the matrix be an alternative for your case?

If you use an aggregation like SUM for the myTable[Coumt] column you already get the subtotals by product. So maybe subtotals are not necessary:

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[selimovd · Accepted solution]

Hey @BishwaR ,

sadly there is no subtotal for a table visual. The subtotal exists only for the matrix visual.

Would the matrix be an alternative for your case?

If you use an aggregation like SUM for the myTable[Coumt] column you already get the subtotals by product. So maybe subtotals are not necessary:

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[BishwaR]

Thank you so much for the response. But there is a Date column also I did not the mention  earlier becuase  I did not want to make it complicated. So the sample report from Excel has a subtotal row at the end of each Product Category. May be I will swtich to Matrix. Thanks again

[selimovd · Accepted solution]

Hey @BishwaR ,

then the Matrix is your only option.

Best regards

Denis

[BishwaR]

Thank you