Forum Discussion
Helper VShow Subtotal in Table
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
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
4 Replies
- selimovd
Most Valuable Professional
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 regardsDenisBlog: WhatTheFact.biFollow 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
