Pivot Table Comparison

C

Crownman

Hi

I have a database that includes the following fields:

Sales - 2012 (by month)
Sales - 2013 (by month)
Sales Goal - 2013
Sales to Goal = Sales Goal - Sales 2013

I am trying to create a pivot table calculated field that will measure the % change vs. 2012 that will achieve the Sales Goal - 2013.

I think all I need to do is do something to get the 2012 full year sales less the 2012 YTD Sales and then compare the Sales to Goal field with this new field.

Can anyone help with this?

TIA

Crownman
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linear Regresion. Sales By Year. 1
How to ignore a column of numbers in Grand Total for rows 1
Help with time function 7
compare date range with date in columns and input data from another cell 2
Formula to fill cells based on Date of Arrival and Date of Departure 1
How do I combine records from different sources 0
Assign Values Based on First Record in Group 2
Batch Pivot Table update 0

Top