flashgordie
Board Regular
- Joined
- Jan 9, 2008
- Messages
- 97
- Office Version
- 365
- Platform
- Windows
I have a data source that deals with items going to customer on deposit. If they take one widget, there is a sale of 1, when they return the widget, there is a sale of -1. resulting in a Zero.
I have attached a picture. Over hundreds of customers and thousands of transactions, we can be dealing with a very long list showing both customers that have completed all of their returns, and those that still have widget to bring back. Withing the pivot table we would like to hide, eliminate, or filter our the zero's. As in my example I would like to hide Jane Sid and Ed. There are a couple of suggestions on the net, but many of them deal with filtering out the zero in the header of the pivot table, however as you can see, my data source has no zeros. Any ideas? TIA!
I have attached a picture. Over hundreds of customers and thousands of transactions, we can be dealing with a very long list showing both customers that have completed all of their returns, and those that still have widget to bring back. Withing the pivot table we would like to hide, eliminate, or filter our the zero's. As in my example I would like to hide Jane Sid and Ed. There are a couple of suggestions on the net, but many of them deal with filtering out the zero in the header of the pivot table, however as you can see, my data source has no zeros. Any ideas? TIA!
| Data Set | Pivot Table | ||||||
| Name | Qty | Sum of Qty | |||||
| Bob | 1 | Name | Total | ||||
| Bob | 1 | Bob | 1 | ||||
| Jane | 1 | Jane | 0 | ||||
| Jane | 1 | Ken | 2 | ||||
| Bob | -1 | Sid | 0 | ||||
| Ken | 1 | Ed | 0 | ||||
| Ed | 1 | Grand Total | 3 | ||||
| Ken | 1 | ||||||
| Sid | 1 | ||||||
| Ed | 1 | ||||||
| Sid | 1 | ||||||
| Bob | -1 | ||||||
| Bob | -1 | ||||||
| Bob | 1 | ||||||
| Jane | -1 | ||||||
| Jane | -1 | ||||||
| Bob | 1 | ||||||
| Ken | 1 | ||||||
| Ed | -1 | ||||||
| Ken | -1 | ||||||
| Sid | -1 | ||||||
| Ed | -1 | ||||||
| Sid | -1 | ||||||
