Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
As shown in attachment, what I want is something like this:
I have a pivot table, inside that there are two dimentions: 1. Month(Apr, May, June) 2. Mxyz(M1,M2,M3....). and I have an expression for count(fieldname).
Now look at the image that I have provided.
I have calculated running sum using rangesum function. Now I wanted to calculate percentage(running sum/ total)
Look at Row 7 for example: 3.42/6395.61=0.05%, 12.94/6395.61=0.20%
please suggest. . .
try this expression
(sum(fieldname)/sum(total fieldname))*100
example-
sum(fieldname) = 3.42
sum(total fieldname) = 6395.61
Then output =0.05%
Thanks vishwaranjan for your efforts. . .
But I have to do running sum of 15 columns. i.e rangesum(Before(sum(fieldname),0,15)), then this rangesum/total of this all rangesum. . .
We can do it using individual 15 different expressions, but that's stupidity. . .wanted more dynamic expression. . .
please suggest. . .