Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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
Product | Rank | Volume |
---|---|---|
A | 1 | 60 |
B | 2 | 50 |
C | 3 | 40 |
D | 4 | 30 |
E | 5 | 20 |
F | 6 | 10 |
Top 6 Product by sales of other market
Product | Rank |
---|---|
G | 1 |
H | 2 |
I | 3 |
J | 4 |
K | 5 |
L | 6 |
Can both the tables come under single view using cyclic group(Expression).
Regards,
Akshay
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
Thanks Sunny for your reply.
Is their any other solution for the same?
Not that I know of, but may be someone else can help you out
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...
Hi Digvijay,
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 -
Product | Rank | Volume |
---|---|---|
A | 1 | 60 |
B | 2 | 50 |
C | 3 | 40 |
D | 4 | 30 |
E | 5 | 20 |
F | 6 | 10 |
2nd cyclic option -
Product | Rank |
---|---|
G | 1 |
H | 2 |
I | 3 |
J | 4 |
K | 5 |
L | 6 |
Can you take a look at the attached:
Hi Thirumala,
This is what i was looking for, can you please share how this was achieved(cyclic for expression).