I am trying to design a chart which will show stock items that have NOT been sold as well as those that have. I know that I can use the dimension setting to "Show All Values" but I want to be able to apply a filter first to show only those items within the selected stock group.
The idea is to show what related items that a customer is not buying.
Thanks for your reply, Ashish, but this does not achieve what I need. My example - I have 3000 stock items of which 50 are in a group called "Accessories". Of these 50 items, I have sold 30 to a customer. Having selected both that 1 customer and only the Accessories stock group, I want to show the sales values of the 30 items as well as showing 0 sales for the remaining 20 items. Is there a way of doing that?
When I uncheck the Suppress Zero-Values, I get a list of all 3000 items.
