function And Measure

[aditya_pratap]

@Michael_Tarallo @mbj @petter @richbyard @Mp3Leaks @rohitk1609 @Marcus_Spitzmiller @ergustafsson @Masaki_Hamano @Sue_Macaluso 

Please help me in this ques this is just an example i have a large data . I want quantity percentage according to level wise total.in Excel file or photo u can see that mango is having 45 so we divide 45 by 120 but in mango subpart we  have first quality and second quality for first quality we have 20 so we divide 20 by 45 like this and like we have two main part fruits and vegetable so for fruits we divide 120 by 220 and for vegetable we divide 100 by 220.

Please help me in this to write measure or function to get percentage level wise.

[MayilVahanan]

Hi

Try like below

Exp: if(Dimensionality()=1, Sum(Qty)/Sum(Total Qty),
if(Dimensionality()=2, Sum(Qty)/Sum(Total<Main> Qty),
Sum(Qty)/Sum(Total<Main,SubPart> Qty)))

[aditya_pratap]

not working

[MayilVahanan]

Hi

what is the issue?

[aditya_pratap]

this is the example excel file gl is main reporting gl sub part then pricing driver 1 and then pricing driver 2 please help me in this 

please help me in this.

GL

Reporting GL

Pricing Driver 1

Pricing Driver 2

[aditya_pratap]

Please help me in this .

This is the example excel file gl is main reporting gl sub part then pricing driver 1 and then pricing driver 2 please help me in this 

please help me in this.

GL

Reporting GL

Pricing Driver 1

Pricing Driver 2

[MayilVahanan]

HI

Try like below

PFA

if(Dimensionality()=1, Sum([Net Ship GMS])/Sum(Total [Net Ship GMS]),
if(Dimensionality()=2, Sum([Net Ship GMS])/Sum(Total<GL> [Net Ship GMS]),
if(Dimensionality()=3,
Sum([Net Ship GMS])/Sum(Total<GL,[Reporting GL]> [Net Ship GMS]),
Sum([Net Ship GMS])/Sum(Total<GL, [Reporting GL], [Pricing Driver 1]> [Net Ship GMS])
)))

[aditya_pratap]

hi Good Evening,

When i using this measure , if i select only one date i am getting right values but if i am taking multiple or range of dates then the value is getting distributed among all dates and i am not getting correct values.
Kindly help me in this.

Thanks

Aditya