Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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