Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
cmccafferty
Contributor III
Contributor III

Setting a filter within a table

Hi,

Is it possible that i can write something into my table, so that only values where [BD SellingCurrency] = 'CAD' is shown on the list of bookings that gets returned?

qv1.png

3 Replies
vamsee
Specialist
Specialist

As you have multiple Dimensions. Try creating the condition in your expressions.

{< [BD SellingCurrency] = {'CAD'} >}

Or

(not recommended)

Add Calculated Dimension IF( [BD SellingCurrency] = 'CAD' , [BD SellingCurrency] )

cmccafferty
Contributor III
Contributor III
Author

Sorry not quite sure where to put this formula in.

vamsee
Specialist
Specialist

In the expressions.

You can post your expression for me to help you with it.