Conditionally enable a column in straight table using Expressions cyclic group

[akshayjain90]

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

[sunny_talwar]

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

[akshayjain90]

Thanks Sunny for your reply.
Is their any other solution for the same?

[sunny_talwar]

Not that I know of, but may be someone else can help you out

[Digvijay_Singh]

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.

[trdandamudi]

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...

[akshayjain90]

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.

[akshayjain90]

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

[trdandamudi]

Can you take a look at the attached:

[akshayjain90]

Hi Thirumala,

This is what i was looking for, can you please share how this was achieved(cyclic for expression).