Limit Product Table by Sales

[rustyfishbones]

Hi All,

I have a product table with 20000+ product codes.

Only 2000 of which have had sales in the last 2 years

How do I reduce the table down to only Product Codes that have Sales >0

Thanks

Alan

[Gysbert_Wassenaar · Accepted solution]

Create a straight table with Product Code as dimension and as expression for example sum({<Sales={'>0'}>}Sales). The part that limits the records to only those with positive sales is {<Sales={'>0'}>}. Put that in the aggregation functions in your expressions.

[rustyfishbones]

Thanks, that works