Sum total from sum if

[warfollowmy_ver]

Hello!

Guys how to get sum as in Excel sumif ? =)))  The attachment.

[swuehl · Accepted solution]

Maybe like

=sum(TOTAL Aggr( if(sum(Sales)>=20,sum(Sales)),Shop,Catalog,Product))

[Anonymous]

Hi,

Please, try this expression :

=Sum(TOTAL Aggr(if(sum(Sales)>=20,sum(Sales)),Product))

Hope it helps.

Regards,

Filip Duchateau

[warfollowmy_ver]

Thank you!