Rangesum/cumulative for each columns and grand total for each columns

[Srinivas]

Hi All,

I wanted to show in pivot table rang sum /Cumulative sum and grand total for each sum in QlikView.

I am trying to create the grand total or cumulative sum but it's displaying only first column, Remaining two columns are shows the zeros.

Current result: 

Expected Result:

Please find the attached sample file the same.

Thank you.

Regards,

Srinivas

[Anil_Babu_Samineni]

If it is straight table, you can play your measures like

RangeSum(Above(TOTAL Sum(Price), 0, RowNo(TOTAL)))

If it is Pivot table,

RangeSum(Below(TOTAL Sum(Price), 0, ColumnNo()))

Description: 

You should use "before" and ColumnNo() because your table is right foward and in horizontal.

For vertical accumulation use "above" and RowNo().

[Srinivas]

Thanks for quick reply,

I have tried but it was not coming the as expected result, Kindly share me sample application.

Thanks,

Srinivas

[Anil_Babu_Samineni]

Thanks for your app, you mean like this

[Srinivas]

Hi Anil,

I wanted to show in pivot table for cumulative sum and grand total not in straight table and other columns no need to for cumulative, I have tried to create report by using of range sum but only first column shows the values but remaining all columns showing the zeros, Please help me in pivoted table itself with those static dimensions.

Please find sample app for the same,