H
hile
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
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?
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?