Pivot Table Calbulated Field
 

PT ? . I am creating a sales report that has lbs and sales pulled from a data
source. I have a calc field that is calc $/lb that is working fine. I want
to create another Calc Field that is the $/lb - the average commodity price
that my industry uses as a bench mark. I can set this to work with a fixed
average price for the month, the problems come when I want to set this up for
multiple months and the average monthly price changes each month. Since the
(Ex $0.28) is fixed in the formula it can't change from month to month. Is
it possible to create a named/field that could change by month.
--

--
CCO