Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
exporting summary data for pivot table!
hi all! i am having a database of sales turnover for differenct products of different companies for a period as under: COL"A" - MONTH & YR COL"B" - COMPANY NAME COL"C" - PRODUCT NAME COL"D" - UNITS SOLD COL"E" - VALUE SOLD JAN05 - X - XX - 10 - 1000 JAN05 - X - XXX - 5 - 400 FEB05 - Y - YY - 20 - 500 MAR05 - X - XX - 5 - 500 MAR05 - Y - YYY - 10 - 600 MAR05 - X - XXX - 20 - 2000 | v | v what i want is to extract the periodwise, companywise, productwise totals of units sold (COL"D") & value sold (COL"E") and export it to another worksheet under the same column headings so that i can create a pivot table for further analysis! is there any easy way to achive this thru xl formula or by any other method? expecting help! -via135 -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=507355 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
How do I restore original Pivot Table data? | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Another Exciting Data Table Question!!!! | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) |