Skip to Content
0

How to create query key figure is divided by overall result of another key figure

Jul 24, 2017 at 03:16 AM

47

avatar image
Former Member

User ask me to create query below.

Please help me with this?

				        KF1	KF2	  **Expected Column**
Fund 1			 	30	17.5	  = 17.5/30 = 0.58
	Functional Area 1	10	10	  = 10/30	 = 0.33
	Functional Area 1	15	5	  = 5/30	 = 0.17
	Functional Area 1	5	2.5	  = 2.5/30	 = 0.08


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Anand Kumar Jul 24, 2017 at 06:01 AM
0

Hi,

Create a restricted key figure with constant selection on Fund 1.

regards,

Anand

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Anand Kumar,

Thank you for your answer.

But User can change fund and drilldown other characteristic replace fund.

0

Hi,

Take all characteristic under constant selection.

Regards,

Anand

0
Koen Hesters Jul 25, 2017 at 01:11 PM
0

Hi use formul SUMGT


hjgjy.png (6.7 kB)
Share
10 |10000 characters needed characters left characters exceeded