Pivot table total sum not working properly

[nisha_rai]

Hi ,

Please help me to resolve the total issue in pivot table, based on the condition I want to show the sum after that in top column wise total .

Eg: if(rangesum(above(total sum(A),0,Rownno(total)))<=Sum(B),Sum(A),0)

result of total is not coming correctly.

please have a loo the screen shot.

As you see the conditional value total is not coming correctly.

Pivot

[nisha_rai]

Can you help me , how we can calculate the cumulative sum in back end

[Channa]

HI if you are using oracle try

Over Partition Function

[nisha_rai]

I am not using oracle, I am doing cumulative sum in Qlik Script.

[sunny_talwar]

---

@nisha_rai wrote:

Can you help me , how we can calculate the cumulative sum in back end

---

Sure thing, please provide some sample data and the output column values you expect to see out from it?

[nisha_rai]

Hi ,

Please have a look the below sample data

ID	Date	Amount	Cumulative Sum1	Cumulative Sum2
1	1/2/2018	10	10	0
2	1/3/2018	20	30	10
3	1/4/2018	10	40	30
1	1/2/2019	20	20	0
2	1/3/2019	5	25	20
3	1/4/2019	10	35	25
1	1/3/2019	6	41	35
2	1/4/2019	5	46	41
3	1/5/2019	10	56	46

I want Cumulative Sum1 and Cumulative sum 2 in back end script, in front end it's possible with the help of Above function .please have me to calculate the cumulative sum in back end.

Thanks.