I have a Pivot Table that has over 7000 data items in the dataset. I need to report on only the negative numbers in the Amount Field. How do I limit the reported data to show only the negative values?
The filter box does not allow for extraction based on values. The value filters on the row only brings up a list of all values and negatives can only be un checked with the mouse/keyboard -- too many to do.
There has to be a function that does this, but I can't find.
Thank you in advance for your help!
The filter box does not allow for extraction based on values. The value filters on the row only brings up a list of all values and negatives can only be un checked with the mouse/keyboard -- too many to do.
There has to be a function that does this, but I can't find.
Thank you in advance for your help!
