Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
put product in dimension
the write this expression
if(count(OrderdId)=0,1,0)
put product in dimension
the write this expression
if(count(OrderdId)=0,1,0)
Thanks Iiron, that helped. Exactly what i was looking for. 🙂