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