Create Calculated Total MS Access Pivot Table
Posted on 2010-08-26
I have a pivot table with two fields in the detail section (main/center part of pivot table) for each employee.
ie Smith Johnson Davis
1 4 3 3 5 4
Goal is to have a count of employees with one number greater than the other.
In Excel I can accomplish this with a formula: =COUNTIF(B5:F5,">="&G5)
I'm only getting errors in Access with no success. In fact, anything I try in "Create Calcuated Total..." causes errors. ie( The query could not be processed: )
Can anyone tell me how to add a calculated total for a pivot table in MS Access 2007 ?