Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Help
I have two sperate sheets of data in a Workbook. The data is as follows:
Sheet 1 data Location SKU Description P.O. PRICE2 Invoice Price Variance Sheet 2 data Location SKU Description Standard Cost P.O Price1 Variance How can I create a pivot table with the following layout ROW COLUMN Location P.O. PRICE2 Sku Invoice Price Description Variance Standard Cost P.O Price1 Variance Thanks, Rashid |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Help
You could try the following.. In the first sheet add some extra column headings that are the same as the headings from the second sheet that are not already in the first sheet. In the second sheet insert some blank columns so everything lines up with the column headings in the first sheet. Copy/paste the data from the second sheet as additional rows on the first sheet. Create the pivot table in the normal way dragging the required data fields into the data area. Create calculated fields to show the required variances regards.. -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=522520 |
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) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |