LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default URGENT PLEASE! Filtering a Pivot Table further

Win2K Excel 2003 SP2 - I'll TRY to be specific but brief

I have a massive table 6000+ recs of customers' unit transfers by unit #,
and I need to quickly find out which customers experience a split-fleet
transfer. Meaning, Cust X has 10 units in Loc A and 8 units were transferred,
5 went to Loc B and 3 went to Loc C. Looks something like this (but with lots
more columns):

Unit # From Dist From Locn From Cust TO Dist To Location
196867 0254 13 643274 5142 10
251042 0011 11 631249 6784 10
251047 0011 11 631249 6784 10
251832 0051 13 637202 0465 10
251851 0051 13 637202 0465 10

Now I created a Pivot because it was the easiest (on my eyes) to quickly
spot the split fleets as it merges the cells. So I just look for those cells.
Problem is the Pivot too is huge and I need a report of JUST the customers
with split fleets. The pivot looks something like this:

From Cust From Dist From Locn TO Dist To Location Total
604657 0040 13 7043 10 2
604851 0011 14 6850 10 8
0051 11 5768 10 1
0722 11 5909 10 3
605058 0722 11 5909 10 1
605095 0426 10 0030 10 4
0446 10 3
609358 0449 15 5082 10 36
0451 10 6021 10 1
12 6021 10 25
609475 0040 14 7107 10 63
613537 0051 11 5768 10 6
0722 11 5909 10 12
14 5976 10 7
15 6028 10 7

From the above I only need a report that shows me:
Cust(s)
605095 Because it went from 0426 to 2 diff dist
613537 Because it went from 0449 to 3 diff dist, BUT I don't need 0051 to show

Notice I didn't pick
609358 0451 Because it went to the same district

I can't "deselect" district #s because it will take them off of all cust(s)
who have that district, and it may apply to the dist for a diff cust. I can't
create a macro because that still will take too long to perform all the
"hides" and I would still not be able to "hide" dist from the same cust # and
just leave what I need. Plus, I keep generating new outputs to refine the
data and if the Pivot changes I don't think the macro will then work.

Is there anything I can do to perform this task quickly. VBA...anything!
Sorry for the long thread and thank you to anyone who tries to help me. I'll
be more than happy to share the file offline.

--
Hile
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert a row after a pivot table MarkM Excel Discussion (Misc queries) 0 July 19th 06 09:19 PM
Pivot Table external XLS file source change and GETPIVOTDATA refresh mbobro Excel Discussion (Misc queries) 0 July 8th 06 12:45 PM
pivot table created from another pivot table Kreed Excel Worksheet Functions 6 October 26th 05 04:16 PM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM


All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"