cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SAC - Two Calculated Measures in the same Table Cell

Domae
Participant
0 Kudos
1,396

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.

  • Four of them are restricted measures, which displays the measures for a specific time period.
  • The fifth column is a calculated measure, which compares two of the periods.
  • The rows are showing the Product dimension.

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

View Entire Topic
former_member762678
Discoverer
0 Kudos

Hi Dominik,

Are you able to find the answer to your problem. I am also facing the same issue.

Regards,

Dhruv

Domae
Participant
0 Kudos

Hey Dhruv,

Unfortunately not :(. We stopped working on this Report. But if you find a solution, let me know!

Regards,

Dominik

former_member762678
Discoverer

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

fbu004
Associate
Associate
0 Kudos

Thanks for the tips! Do you mind explaining " Calculate column J in the table" in more detail? I encountered the same problem, still struggling... Thanks so much!

N1kh1l
Active Contributor
0 Kudos

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