I am making a purchasing plan with pivottable. On column field I have two
status of orders: firmed order and forecast order, and quantity for each
coming months as data.

Now I add a calculated field to calculate the purchasing order for firmed
order, however, that will add the same calculated field to other forecast
order as well, which I don't need it.

How to put a calculated field for one item in column field, but not the
others? Thanks.

May I elaborate more, in my pivottable:

(row field) (column field)
Firm order
Forecast order
August
Sept Oct Nov
Product A (Data field)

I have order status (Firm order/ Forecast order) and Months in my column
field. And I add a calculated formula at data field to see how many order
quantity I should place to vendor. However, the formula will be shown at both
Firm order and Forecast order, which I want to hide for Forecast order as by
defination there is no order quantity for Forecast order.

How to make my calculated formula only show at Firm order but not Forecast
order? Thanks.

"Angus" wrote:

> I am making a purchasing plan with pivottable. On column field I have two
> status of orders: firmed order and forecast order, and quantity for each
> coming months as data.
>
> Now I add a calculated field to calculate the purchasing order for firmed
> order, however, that will add the same calculated field to other forecast
> order as well, which I don't need it.
>
> How to put a calculated field for one item in column field, but not the
> others? Thanks.