Sum total column of table pivot

[#1]

Hi

I´m new in QLIKVIEW  and i´m doing a report, but, i have a problem i need going adding total of each row in the prior column and put it in the next column.

Table Pivot

Day	DATE	Identification Number	Column Prior	sumtotalColumnprior
1	FEB/2015	57555666	10%	10%
2	FEB/2015	4444444	15%	25%
3	FEB/2015	8888845	25%	50%
4	FEB/2015	654465887	50%	100%

[maxgro]

maybe with the rangesum and above function

rangesum(above(expressionofcolumnprior, 0, RowNo()))

[Anonymous]

Hi ,

here You can write expression like this,

=Sum(aggr (rangesum(above( total sum({<Day = ,DATE =,[Identification Number]= >}[Column Prior]),0,RowNo(TOTAL))),Day,DATE,[Identification Number]))

Check the attached application

Thanks ,

Bunny