Horizontally accumulation of a sum

[#1]

Hi folks,

i have a pivot table with all days of a month. I sum the sales of one day and the accumulative Sales.

This works fine.

Day	Sum(Sales)	RangeSum(Above(TOTAL Sum(Sales), 0, Rowno(TOTAL)))
1.10	10	10
2.10	20	30
3.10	30	60
4.10	40	100

But it want to have the day Dimension horizontally:

Day	1.10	2.10	3.10	4.10
Sales	10	20	30	40
accumulative sales	10	30	60	100

A straight table with a horizontally day would also fit.

How should the expression for horizontally accumaltion of the sum look like?

Thank you
Jürgen

[jagan]

Hi,

Convert Straight table to Pivot table, and drag the Day column on top the header of the table.  If expression is not working then try Before() instead of Above().

Hope this helps you.

Regards,

Jagan.

[#3]

Hi Jagan,

thanks for the tip with Before. I changed rowno to ColumnNo and i got a working  expression.

Pivotable with horizontally day -> Expression for  accumaltion of the sum:

RangeSum(Before(TOTAL Sum(Sales), 0, ColumnNo (TOTAL)))

[idogridish2]

Thanks!

[tiklabaq]

Thanks Jürgen!!