Prev: España
Next: Windows 7
From: Nicky on 25 Feb 2010 09:41
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
Customer
Date
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 in Advance

 | 
Pages: 1
Prev: España
Next: Windows 7