Table Box with filtered field values

[#1]

I am trying to create a table box chart and for one of the available fields "SI Programs" I only want to display 2 specific values (Growth and TBA).  The field currently has 8 values but the others are irrevalent to what I am trying to display.

Is there a way to add a fitler like if(SI Programs = 'Growth' or 'TBA', SI Programs)?  I cant see how to add an expression as a field in the table box.

[Anonymous]

Steve

You will need to use a Chart of type Straight Table, and then quite likely Set Analysis in your expression.

Best Regards,     Bill

[Anonymous]

Or create an additional field in the script:

if(match("SI Programs", 'Growth', 'TBA'), SI Programs, null()) as "SI Programs Restricted"

Regards,

Michael

[#4]

how would I use set analysis for the expression.  Not sure what function i would use against the "SI Programs" field since I am just trying to return text values.

maybe max()

[Nicole-Smith]

For a dimension:

=aggr(only({<[SI Programs]={'Growth', 'TBA'}>}[SI Programs]), [SI Programs])

or

For an expression:

only({<[SI Programs]={'Growth', 'TBA'}>}[SI Programs])

It all depends on how you're setting your table up if you need the dimension or expression.