Skip to Content
0
Jul 22, 2021 at 09:30 AM

SAC: How to include Measure Value into Cross Calculated Measure

784 Views

Hi SAC Experts,

I need to use Cross Calculation to hit the requirement of the Finance department to switch between different Measures for different calculated Measures. (See reference Article)

This is working nicely if I just need to create Restricted Measures with Cross calculation.

However I need to create a Run Rate of an existing measure -> Which is working fine if I just create a calculated measure without cross calulations:

Formula: Measure(with Value) / Actual Month * 12 (Months) = Run Rate (Cost for Full Year on Average)

But in cross calculation, I can not select the aggregated Measure Selected_Month (or any other Measures or Dimensions)...

Is there a way to get this value from Selected_Month (Aggregated Measure) into this Cross Calculation?

Thanks and greetings

Attachments

bfuvj.png (13.7 kB)
pidxb.png (58.0 kB)
ahga4.png (69.4 kB)