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

[trdandamudi]

Please see the attached word file along with the screen shots and hope this helps... Also if you think you got your answer can you please close the thread by marking correct answer appropriately.

[akshayjain90]

Hi Thirumala,

Thanks for all the help.

But I want the same functionality without adding any new column(Product by sales or Product by Rank).

Can we achieve the same without using extra column.

Akshay

[trdandamudi]

You cannot avoid the column but you can make it blank without showing Product by Sales /Product by Rank. See if the attached is acceptable:

[akshayjain90]

No, we cant keep the blank column.

[trdandamudi]

Ok. Then you can use the list box for the selection and it will get rid off the extra column. See attached: