I have a chart that has to be linked to some filters and disable from others. I try to use alternate states but that solution disable all the filters. I want only to disable some of them.
As an example: My chart has to be linked to Year and Month of the default state but when I click on, let's say ProductName, I want that the ProductName doesn't appear in current selections. Anybody knows how can I do that?
Thanks in advance.
Thanks for your replies!
I need help here:
I have this in a caption:
='Product Sales, '&Only(Mes)&' '&Only(Ano)
However, this caption is in a chart that has one alternate state and I want the month and year of this caption from default state. I can I use the same strategy here?