# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for
Did you mean:
Contributor III

## Accumulation in a Pivot Table

Hi ,

I am trying to create a pivot table where I have to show the Year (dimension) and Count of Customers (Measure/Exp). I have shown this is a bar chart and accumulated the count of customers over years. The approach is very simple in a bar chart. Just click on the accumulation and it works. But the user wants to see the same information in a pivot table.

Now when I calculate the same in the pivot, there is no option to perform an accumulation. Can someone suggest me how to do accumulation in a pivot table.

The requirement is a bit urgent. Any help is highly appreciated.

Thanks

Ishika

1 Solution

Accepted Solutions
Contributor III

Hi,

Like Neelam mentioned, you have t use the function RangeSum combined with Before or Above.

If you want to do accumulation in the columns you should use

 RangeSum(Before(Count(Customer), 0, ColumnNo()))

If you do accumulation in the rows, you should use

 RangeSum(Above(Count(Customer), 0, RowNo()))

The use of TOTAL depends if you want to sum all the values or just the ones that are displayed in the pivot table.

The use of the number 0 (zero) as the second parameter depends if you want to include the current row/column, if not, you can use the number 1 (one).

I hope I could help.

Best,

Alexandra.

4 Replies
Specialist II

Try this -

RangeSum(Above(TOTAL Count(Customer), 0, Rowno(TOTAL)))

Contributor III

Hi,

Like Neelam mentioned, you have t use the function RangeSum combined with Before or Above.

If you want to do accumulation in the columns you should use

 RangeSum(Before(Count(Customer), 0, ColumnNo()))

If you do accumulation in the rows, you should use

 RangeSum(Above(Count(Customer), 0, RowNo()))

The use of TOTAL depends if you want to sum all the values or just the ones that are displayed in the pivot table.

The use of the number 0 (zero) as the second parameter depends if you want to include the current row/column, if not, you can use the number 1 (one).

I hope I could help.

Best,

Alexandra.

Contributor III
Author

Hi Alexandra & Neelam,

You guys are awesome.  One more help needed.

Since I have the expression by Customer Join Month, the last month has the maximum value. I want to sort this table now in desc order. But when I sort it in desc order, the 1st month starts showing the maximum value after sort. I know that this is because of the expression.