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

You can't use names in a Calculated Field formula. Perhaps you could
insert a new column in the source data, and calculate $/lb with the
fixed price there. Then, add that new field to the pivot table.

Cory wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

I have tried that and it works at the detail level, but when the data is
summarized (by plant let say) it sums it vs. just calculating off of the data
shown.
--
CCO


"Debra Dalgleish" wrote:

You can't use names in a Calculated Field formula. Perhaps you could
insert a new column in the source data, and calculate $/lb with the
fixed price there. Then, add that new field to the pivot table.

Cory wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html