We need to calculate Absolute variance between 2 Key Figures. We were able to calculate the variance in weekly buckets correctly. The user want to see 87 ( 483 – 396) instead of 297 when he checks the data in monthly buckets. How can we control this behavior.
W1 W2 W3 W4 W5 Monthly KF1 83 83 83 83 127 396 KF2 28 128 36 188 172 483 Variance 55 45 47 105 45 297
How can we achieve this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.