on 2022 Jan 06 11:06 AM
Hey guys,
I have a simple table in a SAC report based on a dataset, which I created from an uploaded CSV file. In this table I have five columns with calculated measures.
So far so good. Now I want to add a new row at the end to sum up all values. For the first four columns, this works pretty well, but when it comes to the comparison column, it seems that the calculation for the comparison is ignored and instead the sum calculation overrules the comparison.
So my question is: Can I somehow change this behavior, so that in all cells of the sum row, the sum aggregation should stay but only in the comparison cell, the comparison should still work.
Please take a look at the picture below. The last row is the sum row and the last cell shows a value of 820%, which is wrong, because it is the result of summing up all above percentages.
Best regards
Dominik
Request clarification before answering.
Hi Dominik,
Are you able to find the answer to your problem. I am also facing the same issue.
Regards,
Dhruv
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, fortunately got it !
Both the calculations should be done in the table itself.
Then you can select Column Overrides Rows under Intersecting Calculations Priority .
Since your column J is not calculated in the table itself and is a calculated measure, Column override Rows doesn't work.
Calculate column J in the table and you will get your result. 🙂
Hope it works for you! It did for me
Best Regards,
Dhruv
kmzhuzhu
What it means is that both calculations should be using table formulas calculation. Currently when one is a calculated measure and other a table calculation, setting up calculation priority does not work. In the example above, the row total is a table calculation but column J is a calculated measure.
Nikhil
User | Count |
---|---|
30 | |
22 | |
16 | |
8 | |
7 | |
7 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.