restriction of data being shown through a list box!

[nevilledhamsiri]

Hi!

Is there a way forward for some  data  be excluded from being shown in a table? Eg , if I have a list box for Months & if my requirement is to avoid data being shown for the Month of May how that could be achieved!

Regds

Neville

[its_anandrjs]

In list box you are asking about?

[its_anandrjs]

In Month list box write expression

=Pick(Month,'Jan','Feb','Mar','Apr','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

Or

Best way is use calculated dimension in any List box or in any Chart or you can try this in the loading script also

=if( Match(Month,'Jan','Feb','Mar','Apr','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),Month )

Load

if( Match(Month,'Jan','Feb','Mar','Apr','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),Month ) as NewField

From Source.....

[MarcoWedel]

Hi,

maybe like this?

hope this helps

regards

Marco

[Anonymous · Accepted solution]

Hi,

Please find attached, data restriction in listbox and in straight table.