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
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