Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table woes
I have a pivot table that gives me customer name and the month he last
bought an item and the month he first bought an item, the max. value of the item he bought as well as the min. amount and the category of item(books, apparel, electronics). I want to create a list that reads Customer name Min month of purchase Max Month of Purchase Min amount Max. amount Category Is there a way other than cutting and pasting about 1000 customer names to read it in this format or a drop down list as in the Pivot Table. Thanks, RB |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table woes
To arrange the data horizontally, drag the Data button onto the cell
that contains the word 'Total' There's a picture he http://www.contextures.com/xlPivot02.html ExcelHelpNeeded wrote: I have a pivot table that gives me customer name and the month he last bought an item and the month he first bought an item, the max. value of the item he bought as well as the min. amount and the category of item(books, apparel, electronics). I want to create a list that reads Customer name Min month of purchase Max Month of Purchase Min amount Max. amount Category Is there a way other than cutting and pasting about 1000 customer names to read it in this format or a drop down list as in the Pivot Table. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot table keeps dupping to another linked pivot table | Excel Discussion (Misc queries) | |||
pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
Pivot table woes. | Excel Worksheet Functions | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |