Hello,
I have a pivot table providing a count of a certain category of items, that i have specified by using a series of filters. E.G. There are 400 items in the data set, but only 235 items show up in the count since they apply to the filters.
When I double-click this number to further view the data (a new sheet containing the items is created), I receive a sheet that contains the items represented in the count, as well as other items outside of the filters. The count is correct, yet the data I am getting when I click on the count number includes items that shouldn't be included. Its driving me crazy.
Any help would be appreciated. Thank you!
- J
Bookmarks