pivot table help required I think...

richardrb

New Member
Joined
Sep 28, 2006
Messages
2
Description Criteria 1/2 1/9 1/16
Product A Opening Stock 0 0
Product A Late delivery
Product A Req Prod
Product A Forecast 100 100 100
Product A Sales 200 300 200
Product A Closing 0 0 0
Product A Wks Cover
Product A Forecast Variance 50 66 50

Data layout as above continues for product B, C, D down the page, the desire is to extract a report which only shows the products with a significant deviation between forecast and sales. While I can put a variance calculation into the sheet and extract that with a pivot I really wish to look at an average over a few weeks and then only wish to view those which meet a set criteria i.e. I only wish to view the problem items.

I thought originally I could extract the sales and forecast fig and create a calculated field however am unable to do this as the headers are in the same column.

Looking for some help from experts out there.
Cheers
RB
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Watch MrExcel Video

Forum statistics

Threads
1,133,460
Messages
5,658,899
Members
418,475
Latest member
ExcelBeginner233

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top