Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Tables
I am having trouble with pivot tables. Need to create a pivottable that
summarizes Total amount of orders by quarter. I have these columns company name,country,orderdate, sales rep,shipper, category, product name, unitprice, quantity,discount%,freight, totalamount. I was sure I just put total sales and the order date in but I cant get it to do this in quarters. I am taking a class that the teacher is of no help. thanks -- Too old to be in college |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Tables
Try this:
Right-Click on the OrderDate heading in the Pivot Table ....Select: Group and Show Detail ....Select: Group ....Select: Quarters ....Click: [OK] The individual dates will be grouped by quarters, Note: if you have more than one year in the data, you may want to also group by Year. Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Kimmer" wrote in message ... I am having trouble with pivot tables. Need to create a pivottable that summarizes Total amount of orders by quarter. I have these columns company name,country,orderdate, sales rep,shipper, category, product name, unitprice, quantity,discount%,freight, totalamount. I was sure I just put total sales and the order date in but I cant get it to do this in quarters. I am taking a class that the teacher is of no help. thanks -- Too old to be in college |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Distributing Pivot Tables where pivot table data can't be accessed | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |