I am trying to filter data on my pivot table so only returns items that have a net value > than a certain level
At the moment it is returning the net amount (in the data field that is being summed) but there are a number of returns that are small and would like to remove.
In excel normaly would jsut use the auto-filter and use the >than field, but I can't seem to do that in the pivot?
can anyone help?
Bookmarks