Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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:
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
Thank you