calculating sell through based on running total

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

Help!

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 %

any tech paper numbers, hints or ideas would be much
appreciated! I've tried using an excel worksheet attached
to the access query as a pivot source but the only thing
I come up with are convoluted ugly nested if statements

rr
 

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

Running Total Calculation 2
Creating a Calculated Field From a Running Total Field 1
Calculated Field based on 2 Running Totals in PivotTable 3
Creating a Calculated Field in a Pivot Table for same field 3
Access MSACCESS - Sorting report based on field calculated in the report 0
Pivot Table % calculation 1
Calculated fields in pivot tables 5
Custom Roll up and Drill down calculation for Excel Pivot table 2

Back
Top