2 Replies Latest reply: May 17, 2013 4:45 AM by BRIJESH GADHESARIYA

# Rangesum

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%

• ###### Re: Rangesum

try this expression

(sum(fieldname)/sum(total fieldname))*100

example-

sum(fieldname) = 3.42

sum(total fieldname) = 6395.61

Then output =0.05%

• ###### Re: Rangesum

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. . .