Roggie-Bear
01-13-2011, 10:00 AM
I am using Excel 2007. I have a pivot table (see attached) that is derived from 2 separate data tables. The data tables are the same with the exception of source (open vs. paid invoices). This data is queried weekly and summarized to determine those with balances still remaining. I do this by automatically calculating the amount differences inside of the pivot table.
The issue is that I'd like to filter out those with a zero balance and the pivot table doesn't allow filtering on that column. :help
Thanks for any assistance!
The issue is that I'd like to filter out those with a zero balance and the pivot table doesn't allow filtering on that column. :help
Thanks for any assistance!