Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a Calculated Field in a Pivot Table for same field | Excel Discussion (Misc queries) | |||
Pivot table calculated field | Excel Discussion (Misc queries) | |||
Pivot table calculated field error | Excel Worksheet Functions | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) |