Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a requirement in which I need to distribute a calculated measure proportionately to another measure which is aggregated by dimension. Please find the below example.
Dim. Mes1. Mes2
A 20 20+(20*50)/100 = 30
B 30 30+(30*50)/100=45
C. 50 50+(50*50)/100=75
D. 0 0+(0*50)/100 = 0
calculated 3rd measure is 50
pls let me know the expression for measure 2
Where is this 3rd measure coming from?
dim. Mes1 Mes2 dim
20 Support
30 Support
mes3=20+30 where dim is null
I am not sure I am able to follow... would you be able to share a sample qvf where we can see the data?
Hi,
I attached excel sheet with data. For each dimension1 measure1 will be recorded. measure 2 calculation is available in excel. Measure 1 and measure 2 sum gives the measure 3.
Support multiple projects value is obtained when dimension 1='ABC'
Please let me know if this explains.