Creating a Calculated Field in a Pivot Table for same field

D

dza7

Hello,

I'm having a problem creating a calculated field in an excel 2007
pivot. Here is the scenario I'm dealing with.

* The data this pivot table pulls from has daily sales for a given
month.
* I've set up formulas to recognize if this sales data is from "This
Week" or the "Previous Week".
* I have a pivot table that shows me Sales for "This Week" and
"Previous Week".

I'd like to create a calculated field that will show me the difference
in sales from "This WeeK" and "Previous Week" but the only option I
have in creating a calculated field is to select the original "Sales"
field.

Is there a way to create a calculated field that would show the
difference for Sales for one week to the next? I've run into this
often and usually throw up a formula outside of the pivot table that
can simply do the calculation but I'd rather be able to keep this
calculation within the table.

Any help would be appreciated!

Thanks,

Dza
 
R

Roger Govier

Hi Krystal

I can't see the previous posts in this thread, so I am unclear as to how
your data is set out.
But, assuming as per Herbert's example you date a date field and a Value
field, drag date to the Row Area and Value to the Data area.
Right click on any date>Group and Outline>Group>Days>7
Now drag Value to the Data area a second time>Double click the field
name>Show data as>% Difference from>Date>Previous

If you are still having difficulty and want to send me a copy of your
workbook, I will set it up for you
To mail direct
roger at technology4u dot co dot uk
Do the obvious with at and dot
--
Regards
Roger Govier

Krystal Peters said:
How about for Excel 2003? Need to do the same thing but the Excel 2003



__________ Information from ESET Smart Security, version of virus
signature database 4530 (20091021) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4530 (20091021) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

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

match two conditions to return value from pivot table 1
Automatically Update a Pivot Table Field Used as Column / Row 1
Pivot Table Calculated Field 1
Pivot Table with Percentages 4
Pivot Table - Calculated Field 2
create a calculated field for pivot tables 2
Pivot Table - '% of Total' question 2
Date problem in Pivot Tables when using SQL as a Data Source. 1

Top