I'm trying to calculate the number of Same Day Ticket Closure as a percentage of all tickets.  I have the following in my pivot table:

FILTERS:
Application
Status

ROWS:
CloseDate

VALUES:
Sum of SameDayClosure
Count of Ticket

The idea is to create a calculated field where SDC% = [Sum of SameDayClosure]/[Count of Ticket].  Trying to enter this in the Calculated Field is returning an error as it wants to use [SameDayClosure] and [Ticket] rather than the daily values.

Row Labels Sum of SameDayClosure Count of Ticket SDC%
14/04/07 46 46 100.0%
14/04/08 43 43 100.0%
14/04/09 58 62   93.5%
14/04/10 45 60   75.0%

Thanks!

Adios,

Update:

When I click on the "Row Labels" column, Calculated Items is enabled.  [Count of Ticket] is available in the list of fields but [Sum of SameDayClosure] is not.

Still stumped.

OK - got the formulas figured out.  Now... how do I put %SDC into the PivotTable?

Formulas:

CountTicket=COUNT(Ticket)
SumSDC=SUM(SameDayClosure)
PercentSDC=SumSDC/CountTicket

When I put PercentSDC in the VALUES section, it tries to perform a function on it (SUM, Average, etc).  Good news:  I have the calculated field.  Bad news: I don't know how to display it.