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

[former_member372884]

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

[kohesco]

Hi use formul SUMGT

[Anand71]

Hi,

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

regards,

Anand

[former_member372884]

Hi Anand Kumar,

Thank you for your answer.

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

[Anand71]

Hi,

Take all characteristic under constant selection.

Regards,

Anand