conditional if or filtering in pivot table

[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?

 

[steven1001]

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..

 

[steven1001]

oops "Mort" s/be "Sort"