All - I have the below setup and I'm attempting to find the % difference of the PO's to the Actual(Last Column). So for example the PO JAN16 Grand Total should equal 99.6% of Actual. I thought I could do this with a quick table calc for each measure value, but can't figure it out. I know I could create custom calculations for each PO Measure, but was looking for a faster way?
Hi Kelly,
One cannot make a Table Calculation to Compute along [Measure Names].
So your most obvious solution would be an aggregate measure for each PO, such as:
SUM([PO JAN16]) / SUM([PO MAY16]) - 1
Yours,
Yuri