Wrong percentage Result
I have an Query for Actual and forecast comparison with the percentage values between two Key figures on columns and periods on Rows.
All the percentage values seems ok except result value,
Result value should be using the same calculation as the others which is %A percentage calculation But it is summing up all values.
I already use formula for differentiate The actual and forecast on rows because of this i did try formula collision but it didn't work.
Need to get result with the same Percentage calculation.(%A)
Could you guys help me out?
Thanks a lot