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

    Rangesum

    BRIJESH GADHESARIYA

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