Dear Experts - Need your expert advice. I need to perform calculation on the cumulative values of Key Figure. However I am unable to do so. Cumulated values are not used however original values of KF are used.
As shown above KF2 is a key figure which is displaying cumulative values of KF1 i.e 10,10+25,.... Now I need to divide KF2 with KF3 to get the Expected Results column(as shown above). However, actually the results are coming out to be as shown in column Output Displayed i.e it is dividing KF1 by KF3 instead of dividing KF2 by KF3.
Please suggest how to achieve this requirement in query designer or any other possible option.