Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using Valuelist('Male','Female') as a dimesion and in measures i'm using if(Valuelist('Male','Female')='Male',sum(MaleCount),sum(FemaleCount))
This is displaying values but i want to display percentages too
How can i do that?
Something like this?
if(Valuelist('Male','Female')='Male',sum(MaleCount),sum(FemaleCount))/Rangesum(sum(MaleCount),sum(FemaleCount)))
Umm .not working
Ok , got the solution
i used this in label
'Male'&' : '&sum(Male Count)/num(sum(Male Count)+sum(Female Count),'#0.0%')&' , ' &'Female'&' : '&sum(Female Count)/num(sum(Male Count)+sum(Female Count),'#0.0%')