Get Possible Value for a certain field from Table

[phaneendra_kunc]

Hi

I have a requirement, where i have to show and hide the columns based on the possible field value.

Example:

Product	Indicator
BrandA	Y
BrandB	N
BrandC	Y
BrandD	Y
BrandE	N

in straight table i have 3 columns which they needs to be shown on hidden based on Indicator column.

so if i pick BrandA through BranC, then the possible values are Y,N,Y

we have setuped the columns for each brand in a straight table, based on the field selections.

so in those 3 columns i have to hide the 2nd column as BrandB is N.

Any help is very helpuful

Thanks,

phani

[#2]

Can you add the below expression:

     sum({<Indicator={'Y'}>} 1)

and hide the expression in presentation tab.