Help with displaying data under 9999

[hopkinsc]

Hi, i have attached a file that i need help with.

I only want to display data in the pivot table that is less than 10000, i,e, from 1-9999. All other data i want to exclude. The data is loaded in from a database that i can't access, so all data is loaded in but i dont want to display all data.

Any help would be appreciated.

Thanks

[#2 · Accepted solution]

Lets say the field you want to filter is called Amt...

Using this as your expression will treat values 10,000 and greater as null

if(Amt>=10000,null(),Amt)

[Miguel_Angel_Baeyens]

Hello again,

Try using

Only({< EAN = {'<=10000'} >} EAN)

as expression.

[rwunderlich]

I'm guessing EAN is to be a dimension of the Pivot Table. In that case, use a calculated dimension of:

=if(EAN<10000,EAN)

See attached example.

-Rob