I have a series of line charts, which show the last 5 quarters on the x axis and market share by brand on the y axis
my question is that I have around 50 brands and I only want to show the top 5.
However if I select Top 5 in the Visual Filter, the market share becomes the market share of the top 5 total and not the actual market or Grand Total - which is rather annoying in my humble opinion not correct
I'm assuming at his point I need to have a Total for each chart calculated somewhere and used somehow to produce the market share rather than using the Show Values as Percent of Grand Total - which is confusingly labelled.
Any help here would be welcome, I'm sure someone must have come across this issue and solved it
my question is that I have around 50 brands and I only want to show the top 5.
However if I select Top 5 in the Visual Filter, the market share becomes the market share of the top 5 total and not the actual market or Grand Total - which is rather annoying in my humble opinion not correct
I'm assuming at his point I need to have a Total for each chart calculated somewhere and used somehow to produce the market share rather than using the Show Values as Percent of Grand Total - which is confusingly labelled.
Any help here would be welcome, I'm sure someone must have come across this issue and solved it
