Percentages in Pivot table

  • Thread starter Thread starter Nicky
  • Start date Start date
N

Nicky

i have got a query looking at Sales History against Forecast and want to see
the accuracy to forecast as a percentage in a pivot table.
The fields I have are
ActualSales
ForecastQty
Var: IIf([ForecastQty] Is Null,[ActualSales],([ActualSales]-[ForecastQty]))
Perc: [Var]/[ActualSales]

This all works fine if I run the query but when I try and put it into a
pivot Table it doesn't like it and crashes.

Is there a different way to handle this in Pivot tables.

Thank you
 
Nicky said:
i have got a query looking at Sales History against Forecast and want to
see
the accuracy to forecast as a percentage in a pivot table.
The fields I have are
ActualSales
ForecastQty
Var: IIf([ForecastQty] Is
Null,[ActualSales],([ActualSales]-[ForecastQty]))
Perc: [Var]/[ActualSales]

This all works fine if I run the query but when I try and put it into a
pivot Table it doesn't like it and crashes.

Is there a different way to handle this in Pivot tables.

Thank you
Click to expand...
 
Back
Top