Calculate Percentage from the result of another Key Figure
I want to calculate percentage fro a kf. But wht i want to do is...
I have 2 KFs eg KF1 and KF2.
I did (KF1/ KF2)* 100. but this is not what the users want to see.
(KF1/ Overall result of KF2)*100.
please can someone tell me how can i do this in the Query designer.