Running Total Calculation

[Rick]

I've been trying to calculate sell through % based on
sales data by week by upc. So far I've created a
calculated field based on week sales and week shipments
in a pivot table and then formated these fields as
running totals. When I try to create another calculated
field based on the calculated running totals it doesn't
work. I've played with Dsum (Access source DB) but only
get it to work on UPC or Week not both. Follows is a
rough format

week 1 2 3 4
---------------------------------------
Ship 4 6 2
RunShip 4 10 12
(=Ship w/pivot running total)

POS 2 3 4
RunPOS 2 5 9
(=POSw/pivot running total)

RunSellT% -- pivot calc field =RunPOS/RunShip
this field returns POS/Ship not desired Sell Through %

rr

 

[Paul Corrado]

Rick,

I'm sure that you are anxious to get some input. But please be patient and
refrain from posting the same question multiple times. It is most likely
that someone will reply to your previous post. As of now it has been up
less than 2 hours.

In the interim you can try a search in Google Groups using your keywords
such as "calculated field pivot table" and see what comes up. You may be
able to find the answer you need.

Or you can check Debra Dalgleish's site. She has some information and links
that may be of use.

http://www.geocities.com/jonpeltier/Excel/Pivots/pivotstart.htm

HTH

PC

 

[Rick]

Thanks Paul for the reponse and the tips. Debra's site
is great and I will try the google search. The reason
for my repost was not that of impatience but that after
reviewing the topic line I saw that is was not to the
point. I will refrain from mutiple posts and apoligize
for the faux pas........ rr