Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |