Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Hello again,
Try using
as expression.Only({< EAN = {'<=10000'} >} EAN)
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