Hi
This may sound basic but I am completely stumped. Funny how the simplest of problems can become the most difficult to solve!
I have an issue with a field within my pivot table basically the pivot table will only return a value of 0 when the query returns a calculated value and the pivot table will return the calculated value in the form just not in the pivot table view!
Any help would be greatly appreciated
Cheers
This may sound basic but I am completely stumped. Funny how the simplest of problems can become the most difficult to solve!
I have an issue with a field within my pivot table basically the pivot table will only return a value of 0 when the query returns a calculated value and the pivot table will return the calculated value in the form just not in the pivot table view!
Any help would be greatly appreciated
Cheers