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 )