I Have a requirement where i need to add a column in a straight table, which would be conditionnaly enabled on the basis of cyclic expression.
For Example - If Product by Sales expression is selected in cyclic group(Expression) then volume should be shown otherwise only rank should be shown.
TOP 6 Product by Sales
Top 6 Product by sales of other market
Can both the tables come under single view using cyclic group(Expression).
I don't think you will be able to determine which cycle expression you are on to enable or disable a column. There might be a macro that can be used, but AFAIK, no inbuilt functionality available to do this
Can you share your actual dimension and expressions, may be some alternative can be suggested using show/hide in presentation tab or button/action to switch between two views.
Please take a look at the attached file and see if this is what you are looking for so that you can incorporate this into your dashboard:
Hope this helps...
With the help of button/action I am able to achieve it, but want to know, if expression Cyclic can handle the same or not.
Thirumala - I want to show Volume Column and Rank Column both in one cyclic expression and only Rank Column in other cyclic option.
1st cyclic option -
2nd cyclic option -
This is what i was looking for, can you please share how this was achieved(cyclic for expression).