I don't see why not. It just depends on what result you are looking for in your visualization. When you say the parameters would be "combined", what do you mean? How do you expect the two parameters to behave and affect the viz?
I'm just trying to clarify what your desired outcome is.
So I would like to have 2 parameters. Values for the first one would be:
1. Pack sales
2. USD sales
The second parameter would have these values:
1. R3M (Rolling 3 months)
2. R6M (Rolling 6 months)
3. R12M (Rolling 12 months)
4. YTD (Year to Date)
The values of both parameters would be combined into one (e.g. Pack Sales YTD). This combined value is exactly the same as measure name in the workbook. So I would like to have the combined parameter affecting the choice of the measure.
I believe you could do this, then. You'd show the parameters and write a calc to leverage them. An example might be:
IF [Parameter1]='Pack sales' AND [Parameter2]="R3M"
then [Pack sales R3M]
elseif [Parameter1]='Pack sales' AND [Parameter2]="R6M"
then [Pack sales R6M]
... etc, etc.
Will this work for your purposes? I haven't tested.
It works, I had to create a calculated field for the original Pack sales as you cannot mix agreggated an non-aggreated fields in calculated. Thanks a lot!!
Not a problem, thanks for providing enough detail to provide a decent answer! Usually we bark at you if you don't post a workbook, but this one was doable without it. You dodged that bullet!
Cheers, and good luck.