I want to group this all A as A , and all B as B and so on..
What i want to see in my view is.
To show this two month data using stacked bar chart and i want to see the TOP 3 for that particular month only. if i click sep-18 it should show the top 3 and if i click the oct-18 it should the top 3 for that month only. how to achieve this ?
I need to use parameter , so that i can type in the value so that stack will change accordingly .
if i click the particular month in month filter , the legend will automatically populate according to the value in the stack?
for example. in month September value A, b and d is higher and in the month October, value c, b, d is higher
I want to see in display for month for september is A, B and D and month of october , i want to see C, B and D
if i click both month (September and October), the stacked bar should display both september and october stacked bar chart with thier corresponding value in a form of stacked bar chart.
if i apply parameter and type, the stack should change according to the highest value for both month based on the highest value.
If i type 2 in parameter, it should show the top 2 value only for both month september and october.