Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data which i want to set to a 100% over the dimension month, I would like to display teh % per prod based on a complete month
example: jan: prod a is 60, prod B is 40 so 60% over 40 % stacked in a column for Jan
for feb prod a is 80, prod b is 20, i would like to see for column Feb 80% over 20 %
using relative it's calculating the percentage over all giving wrong results.
any suggestions how to get the above % in a stacked format so every month is set to 100% , see example.
Many thanks! Linda
maybe you didnt' uncheck the "relative" calculation ?
Hi Linda
I know 2 solutions
1) use as expression
=sum(qty)/sum(TOTAL <month> qty)
2) use noofrows
=sum(qty)/rangesum(top(sum(qty),1,noofrows()))
regards
JJ
Hi Jj,
thx, but none of the above gives me a 100% per column on month, i would like each month to roll up to 100% and within this 100% the % of products within that month.
Regards,
Linda
maybe you didnt' uncheck the "relative" calculation ?
Hi Jj,
You are completly right, it works without the relative, seems time to call it a day i guess
regards,
Linda