Custom list of products

[chandran]

Good day

I want to create a custom list of Products with sales. The items with no sales must also be reflected on the sheet. I have the set analysis expression below, but only the items with sales reflect. I need to see a zero against those items that have no sales.

How do I amend this expression?:

Sum({$<[Product Code]={'1023','2014','1029','MKD-02','SM190'},Year={$(vMaxYear)}>}Quantity)

Please assist.

Kind regards

Chandran

[chandran · Accepted solution]

@tresB Ok. Thank you for your assistance.