Percentages in Pivot table

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
 
D

De Jager

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table percentages 1
Turning a 3 column flat file into a "3D" Table 2
Access #Error & Excel Pivot 0
Accumulated Percentage within a Pivot table....CAN ANYONE HELP?!?! 6
Pivot Table as a data collection tool 1
Plotting percentages in a Pivot Chart 1
Wrap Text in Access Form Pivot table 0
Can't save pivot table layout 1

Top