Forum Discussion
Solved
Sum problem in matrix table
Dear All I have trouble with the matrix table. In this table sum of rows are ok, even total grand also correct. However Total sum for each column is wrong. Please help me to solve this problem. ...
Hi,
Try this measure
OPEX_ = SUMX(VALUES(Product_Group[Product_name]),[Per_Unit (main)]*[Deal#count]*-1)
Hope this helps.
Hi,
I think the correct answer should be 7,39,03,024. On the top right hand side of your visual, you will see 3 dots. Click on those 3 dots and select Export Data. Open the Excel file and create a Pivot Table. The total of the Grand Total column will be 7,39,03,024.
Dear Ashish_Mathur
I have checked, you are right. It seems there is something wrong with my upload file. Actually the file I uploaded contains different amount. It seems I need to review upload file.
Thank you very much for your priceless help and patience.
Best Regards
You are welcome. If my reply helped, please mark it as Answer.