Filter Data

[siddheshmane]

Hi,

I have a straight table with data.

I need to filter the data according to a particular value. say "Sales Order".

I want to show data of only "Sales Order" other should not be visible.

Thanks,

Siddhesh.

[sunny_talwar]

Try this as your dimension (and select 'Suppress When Value Is Null' on the dimension tab)

=If(SALESTYPE_FLAG = 'Sales Order', YourDimensionField)

HTH

Best,

Sunny

[siddheshmane]

Hi Sunny,

Have done that in my dimension field. But the filter i want to put is in my expression.  Is it possible.

Thanks.

[sunny_talwar · Accepted solution]

Sure. Add a set analysis statement to your expression:

{<SALESTYPE_FLAG = {'Sales Order'}>}

[siddheshmane]

Thanks a lot Sunny.

[sunny_talwar]

I am glad it worked

Best,

Sunny

[siddheshmane]

One more question. Is it possible to do the calculations on a Table Box instead of a Straight table.

[sunny_talwar]

Table box doesn't allow for calculated expressions. You can only use fields calculated in script.

Best,

Sunny