Forum Discussion
Column figures in Matrix
Hi,
How can I put the breakdown of the sum of the columns in matrix table? It displays the same sum value (image attached). As you can see under the customer name are different product codes, the values of the sub columns under the "Sum of Budget" is the same as the aggregated "sum value" instead a breakdown value.
Any help is much appreciated.
Kind regards,
Marvin
Thanks for the answer, yeah I think no. 2. Probably not a good solution but I did a merge and pulled the column I need, and it seems to work.
5 Replies
speedrampsSuper User
This is a very common question.
Please see Youtube for various tutorials about using SUMX to fix matrix totals.
there are also dozens of abswer to this question in this forum history
https://www.youtube.com/watch?v=Rii_6qkLNh8
https://www.youtube.com/watch?v=eoT-jPzV3Wk
Thanks for the info speedramps
- Ashish_Mathur
Hi,
There could be 1 of the following 2 problems:
1. You have written a calculated column formula instead of a measure
2. The relationships are not proper.
Thanks for the answer, yeah I think no. 2. Probably not a good solution but I did a merge and pulled the column I need, and it seems to work.
- Ashish_Mathur
You are welcome. If my previous reply helped, please mark that as Answer.
