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

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,051
Messages
5,857,047
Members
431,850
Latest member
mbhakt

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