J
Jeff Metcalf
I have a pivot table that
As Rows
Service Territories
As Values
Count the number of service calls
Sum two columns of data consisting of 1 or 0 depending on whether a SLA was
met.
When I try to put in a calculated field of SLA1/callcount, all I get is a
div/0 error?
I can do a manual calc of
=GETPIVOTDATA("Sum of
Met_Response",$A$5,"Area","FL")/GETPIVOTDATA("CallCount",$A$5,"Area","FL")
and it's fine. Why can't I do a calculated formula in the pivot table
itself to do this?
Thanks in advance,
Jeff
As Rows
Service Territories
As Values
Count the number of service calls
Sum two columns of data consisting of 1 or 0 depending on whether a SLA was
met.
When I try to put in a calculated field of SLA1/callcount, all I get is a
div/0 error?
I can do a manual calc of
=GETPIVOTDATA("Sum of
Met_Response",$A$5,"Area","FL")/GETPIVOTDATA("CallCount",$A$5,"Area","FL")
and it's fine. Why can't I do a calculated formula in the pivot table
itself to do this?
Thanks in advance,
Jeff