LinkBack URL
About LinkBacks
Hi,
If you look at the attachment you can see that my pivot is showing the subtotals of the amounts for the suppliers.
I want to filter this pivot so that only the subtotals under 2.000 will be shown.
How can this be done?
Thanks in advance
Hi,
If you look at the attachment you can see that my pivot is showing the subtotals of the amounts for the suppliers.
I want to filter this pivot so that only the subtotals under 2.000 will be shown.
How can this be done?
Thanks in advance
Hi,
I dont think that that function is embeded in the pivot tables (not sure about excel 2007).
One way to do this is to add a helper column to your source data and have the criteria programmed there. In this helper column (call it "subtotal <2000" for example) you could have something like this:
I´m considering Column A as the one having the supplier name and column C the one with the amount.
Please Login or Register to view this content.
You can now add this field to the Page section of the pivot and Select "Yes".
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks