Hi,
I have many criterias and there is only one mandatory which is the year,
I also have for example a criteria month which is optional
In case month is not selected I should display a chart for the year
In case a month is selected I should display a chart for the specified month and I have other optional criterias that can filter data displayed in my chart like category of product ...
So how to do that in one report, conditional blocks?/ creating many pages for each type of possible combination of selected criterias
one page if only year is selected
one page if year and category of product is selected
one page if month is selected .....
I have at least 4 criterias so 8 different pages?
thanks for your answers
If the prompts are set as optional then the data will be automatically filtered according to what the user selects (or doesn't select).
Not sure if I'm missing the point.