Partial Sum calculation in Pivot table

[#1]

Hi Team,

Here I have attached sample qvw.

My Requirement,

1. I need to convert negative numbers [sum(F1-F2)] to zero,for that purpose i have used Range max function

2. I have to calculate Partial sum,while calculating it takes the negative numbers too.But In straight table it is working perfectly

Could you help me to solve this issue.

Thanks in advance.

[jonathandienst · Accepted solution]

Hi

Pivot table 'sum of rows':

=Sum(Aggr(RangeMax(sum(F1-F2), 0), F1, F2))

HTH

Jonathan

[PrashantSangle]

Hi,

Use Aggr()

Try like

SUM(aggr(IF(SUM(F1-F2)>0,SUM(F1-F2),0),F1,F2))

Regards,