Pivitol - Data filtered first is ignored when it is again filtered by Top 10

[Apollo2000]

I am new to pivitol so bear with me.

From a large amount of data in excel tab. I only need few targeted columns for my analysis.
So, I chose those using pivitol (select the column titles I am interested in).
From those selected titles I again filter out different sub items in each column.

I will try example:
There can be multiple enter for each team based on time for that day, so each day can have multiple entries

Name, Year,Time SALES
TEAM A, 06/20/2013,time $200
TEAM B, 04/10/2013,time $600
TEAM C, 11/05/2013,time $800
TEAM D, 02/08/2014,time $150
... , ------, -----
... , ------, -----
.... , ------, -----
TEAM Z, 01/01/2014,time $350

I first filter and exclude ALL Team B entries. then I sort large to small the A,C,D
Say that sort produces a lot of grouped say/time entries. So i filter by date range.
Then each day could have say 1 to 30 entries per day
So I try and sub filter (filter again) using the filter by TOP 10.
Well when I do that it overrides the first filter, and it lists TEAM B entries since it meets the top 10 criteria, even though I filtered it out in my prior step.

Currently the only way I am finding is to delete that from the source referenced but then I am tempering with my master source.

Hope my explanation is clear.

 

[r1c1]

Hi Apollo2000,

Welcome to Chandoo.org forums and thanks for posting your question.

I assume by Pivotol you mean Pivot tables.

You can do one of the 2 things:

1. Use report filters to exclude items you do not want. See http://chandoo.org/wp/2011/04/20/pivot-table-report-filters/ for help on this.

2. Make sure your pivot table set up to take multiple filters per field. This can be done by going to pivot table options in Analyze ribbon and going to Totals & Filters tab. See this image.