| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.charting,microsoft.public.excel
|
|||
|
|||
Deselecting records in pivot table automatically
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? |
|
#2
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
|
Deselecting records in pivot table automatically
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 " 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refresh Pivot Table Automatically | Excel Discussion (Misc queries) | |||
| How do i automatically group rows in a pivot table? | Excel Discussion (Misc queries) | |||
| PIVOT TABLE - hiding records with CALCULATED item values equal to | Excel Discussion (Misc queries) | |||
| unique records in Pivot Table | Excel Discussion (Misc queries) | |||
| "How do I get rid of old records in an Pivot Table? | Excel Discussion (Misc queries) | |||
Linear Mode
