I have a file with over 51,000 rows. I need to pivot the data to get
at 3 different conclusions. I can pivot, but I need to further filter
the pivot and I'm having problems figuring out how.

My headings and some sample data:
Dist_Nbr Customer_Acct_Nbr Customer_Number Bill-to_Company_Name
Bill_Grp
7510 60000100 600001 SUMTER PACKAGING CORPORATION 00
4611 60000200 600002 A SMOOTH MOVE LLC 00
7170 60001200 600012 DOCUMATION INC 00
7170 60001201 600012 DOCUMATION INC 01
0684 60008300 600083 DOCUMATION INC 00



>From this I need 3 lists and I already pivoted the report.


One list gives me Cust #s with multiple bill groups:

DMN CORPORATION 609662 00 13
01 1
50 10
DMR FOOD CORPORATION 609134 00 1
DMT SERVICES, INC. 609396 00 1



One list gives me Cust Name with multiple Cust #s

AARON RENTS INC 601189 00
02
05
601190 00
01
03
AARON RENTS INC #18 601190 00
AARON RENTS INC ST # 2M-389 601190 00


And the last will give me Customer #s, with Diff Bill Groups where
each bill group is a diff customer Name

If you look at the above pivot samples I get records that do not have
multiples and I need to further filter these pivots to show me just
the records I want (i.e. I don't need DMR Food or DMT in the first
pivot and I don't neeed the 2 Aaron entries that just have one bill
group). I can't write a macro because I would still have to "DO" it
and this is going to be a one time thing I can't spend the hours it
will require me to filter this out.

Is there any way I can do this quicker? VBA or something?

If you droped your fields in the pivot table row field just click the arrow
in the heading and filter out what you do not need.
Andrea

"(E-Mail Removed)" wrote:

> I have a file with over 51,000 rows. I need to pivot the data to get
> at 3 different conclusions. I can pivot, but I need to further filter
> the pivot and I'm having problems figuring out how.
>
> My headings and some sample data:
> Dist_Nbr Customer_Acct_Nbr Customer_Number Bill-to_Company_Name
> Bill_Grp
> 7510 60000100 600001 SUMTER PACKAGING CORPORATION 00
> 4611 60000200 600002 A SMOOTH MOVE LLC 00
> 7170 60001200 600012 DOCUMATION INC 00
> 7170 60001201 600012 DOCUMATION INC 01
> 0684 60008300 600083 DOCUMATION INC 00
>
>
>
> >From this I need 3 lists and I already pivoted the report.
>
>
> One list gives me Cust #s with multiple bill groups:
>
> DMN CORPORATION 609662 00 13
> 01 1
> 50 10
> DMR FOOD CORPORATION 609134 00 1
> DMT SERVICES, INC. 609396 00 1
>
>
>
> One list gives me Cust Name with multiple Cust #s
>
> AARON RENTS INC 601189 00
> 02
> 05
> 601190 00
> 01
> 03
> AARON RENTS INC #18 601190 00
> AARON RENTS INC ST # 2M-389 601190 00
>
>
> And the last will give me Customer #s, with Diff Bill Groups where
> each bill group is a diff customer Name
>
> If you look at the above pivot samples I get records that do not have
> multiples and I need to further filter these pivots to show me just
> the records I want (i.e. I don't need DMR Food or DMT in the first
> pivot and I don't neeed the 2 Aaron entries that just have one bill
> group). I can't write a macro because I would still have to "DO" it
> and this is going to be a one time thing I can't spend the hours it
> will require me to filter this out.
>
> Is there any way I can do this quicker? VBA or something?
>
>