Forum Discussion
Show Subtotal in Table
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
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:
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