How many companies do you have and do they change in the date much?
These are 4 separate objects each filtered for a different company
In a grouped bar chart with 2 dimensions you can't suppress the values from the 2nd dimension where expression are zeroes...it will show the whole group each time.
Or you can concatenate the 2 dimensions together and get what you want with a different axis layout:
Test.qvw 157.8 K
Thankyou this is really helpful.
Max 4 companies but a lot of products. Ideally I'd like to keep everything in the one chart as this is part of a larger dashboard and it's important to clearly see how our company compares to the other 3 competitors. That's why I had a trellis in mine.
Edit: Just to note i am open to how the data can be displayed and what kind of chart it is. I just picked bar chart to give an example.