
Creator III
2016-05-17
04:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sum total from sum if
Hello!
Guys how to get sum as in Excel sumif ? =))) The attachment.
1,787 Views
1 Solution
Accepted Solutions


MVP
2016-05-17
11:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe like
=sum(TOTAL Aggr( if(sum(Sales)>=20,sum(Sales)),Shop,Catalog,Product))
1,003 Views
3 Replies


MVP
2016-05-17
11:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe like
=sum(TOTAL Aggr( if(sum(Sales)>=20,sum(Sales)),Shop,Catalog,Product))
1,004 Views

Anonymous
Not applicable
2016-05-17
11:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Please, try this expression :
=Sum(TOTAL Aggr(if(sum(Sales)>=20,sum(Sales)),Product))
Hope it helps.
Regards,
Filip Duchateau
1,003 Views

Creator III
2016-05-17
07:12 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you!
1,003 Views
