Need Help??

[paulwalker]

Hi,

How to calculate cumulative count/sum in pivot table...

Cumulative it should be 1200, 1200+2300,  1200+2300+2100,  1200+2300+2100+3200

PFA,

Thanks in Advance.........

[#2]

Try this code :

RangeSum(Before(Sum(Cost),0,ColumnNo()))

PFA

Regards

Lathaa

[sagarkharpude]

Hi,

PFA

[jagan]

Hi Paul,

You misplaced the Bracket '(' in your expression use this expression below

=RangeSum(before(sum(Cost),0,ColumnNo()))

Hope this helps you.

Regards,

Jagan.

[amit_saini]

Hi Paul,

Backend Script (For example purpose):

LOAD * INLINE [
Month ,Sales
Jan ,1000
Feb ,1500
Mar ,2000
Apr,2500
May ,3000
Jun,3500
Jul,4000
Aug ,4500
Sep,5000
Oct,5500
Nov ,6000
Dec,6500

];

Front End Solution:

• Call Months and Sale as Dimension  on straight table and below as expression to see Cumm result .

=rangesum(above(total sum(Sales),0,Rowno(TOTAL)))

[#6]

Hi,

See this qvw.