Total in Pivot not matching with EXCEL Extracted

[kiranpatil123]

Hi All ,

I have the Below Pivot Table created .

CTscannerPremium and CTscanner_ISP is created by expression sum(CTscanner_Premium) and sum(CTscanner_ISP) respectively . 

What i need from 3rd expression is sum of CTscanner_ISP where CTscannerPremium >0 and CTscanner_ISP >0 ( Filtering out zero's ) .

I tried with below expression 

if( sum(CTscanner_Premium) >0 and sum(CTscanner_ISP)>0 ,
sum(aggr(sum(CTscanner_ISP),[Sales Doc. #],Quarter)))

It is working fine but the total is showing wrong (4234762.98 - this is wrong) , not sure what I'm missing  - OR DO LET ME KNOW IF ANY OTHER EXPRESSION ALSO CAN BE DONE TO GET THE OUTPUT

When i extract pivot to Excel and see the total for expression 3 , its correct but not the total in pivot table . I need the sum what is shown in excel ( sum i need to get is 2764339 , I have attached the extract excel from Pivot Table - can see it for reference ) 

Do help

Pivot Table

[sunny_talwar · Accepted solution]

Try this

Sum(Aggr(
  If(Sum(CTscanner_Premium) > 0 and Sum(CTscanner_ISP) > 0, Sum(CTscanner_ISP)
, [Sales Doc. #], Quarter)))