Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot Table Newbie
I have '03, '04 & '05 sales data, with the following column headings: "Customer Inv Date Item # Qty Price Total" I have sorted the source data first by Customer and then by Inv Date. The Inv Date is in the following format; mm/dd/yyyy. I need total sales by customer by year. I can do a basic Pivot Table and sort it so that it gives me a listing by customer in descending order of total (aggregate of 3 years) sales. My problem is that I can't figure out how to subtotal sales by year. Hope this isn't too confusing - any help would be appreciated!!! -- tech lead ------------------------------------------------------------------------ tech lead's Profile: http://www.excelforum.com/member.php...o&userid=28862 View this thread: http://www.excelforum.com/showthread...hreadid=489308 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |