List products not used

[#1]

Hi,

I have a report listing all orders of a pirticular product, supplier, location and period.

the script has a Orders table and seperate tables for list of products, suppliers, location.

i would like to make a chart/table of all products which have not been orderd (having no records in orders table) for a given period and given suppliers.

Any suggestions on how can we do that ?

Thank you.

kind regards,

Devang.

[lironbaram · Accepted solution]

put product in dimension

the write this expression

if(count(OrderdId)=0,1,0)

[#3]

Thanks Iiron, that helped. Exactly what i was looking for. 🙂