I am trying to do something slightly unusual with a field parameter. I have a situation where my query has the following fields:
Sales, Year, Quarter, Region, Category, Business Unit
I want to plot four bar charts with the Y-axis=Sales, X-axis=Quarter and Legend=Year. For the filters on each chart, I would then like to enable the user to select a field parameter from Region, Category or Business Unit - this parameter would be used to filter each of the charts with the first four values of the selected field parameter.
For example, Region has four possible values (East, North, South and West). If I select Region as the parameter I would want to the first chart to be filtered for Region = East, the second to be filtered for Region = North, then Region = South and Region = West.
Is there a way I can achieve this?
