Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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.
Best regards,
TMF
You can use set analysis to reference another alternate state explicitely, like
sum({<Dim3=[AS1]::Dim3>}Expression1)
See also attached.
Better you can try with set analysis.
/Murali
I already try this but it didn't work...
TMF
You can use set analysis to reference another alternate state explicitely, like
sum({<Dim3=[AS1]::Dim3>}Expression1)
See also attached.
I think this discussion will help you understand how you can use alternate states in set analysis expressions.
Hi
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?
TMF
Ok, I think you just need to reference the default state in your set expression:
='Product Sales, '& only({$} Mes) & ' ' & only({$} Ano)