How to filter the result of an expression field

[adamjwchen]

Hi,

I use pivot table to make a table like below, SALES(TAX) is a field calculated from expression.

Is there any way I can have a list box or something else to filter the expression result. For example, SALES(TAX) >= 2500.

[marcus_sommer]

You could use a search-expression on a listbox for your ID like:

=sum(Sales])>2500

or as an alternatively a listbox with a calculated dimension like:

class(aggr(sum([Sales]), Year, Month, ID), 2500)

- Marcus