conditional if or filtering in pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet with about 10,000 rows containig all the records of the
company's phone calls. I prepared a pivot table showing for each extension
number, the accumulated duration of the calls (minutes), their cost ($) and
amount of calls, but there are about 500 different extensions and I'd like to
filter the pivot table to show just the extensions that contribute with more
cost.
i know how to insert calculated fields in a pivot table, but it seems to me
that I need to filter or put a condition before the pivot table. I tried
using subtotals, but as there are so many rows it takes so long doing that
How can I do it, without visual basic programming?
 
You could try this..
Mort the pivot table in descending order of cost.
Mouse-select all the labels for bottom rows that are below your cost
threshold and right-click and select 'group'. This will create a
single label which includes all the low cost extensions. Drag the field
with the individual extension off the pivot table. Overtype the 'Group1'
label with whatever you choose.
regards..
 
Back
Top