conditional if or filtering in pivot table
 

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?

conditional if or filtering in pivot table
 

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
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=519888

conditional if or filtering in pivot table
 

oops "Mort" s/be "Sort"


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=519888