Pivot table formula with dates

C

candyman

I have a list of applications wth the received date, approved date and
completed date. The PT groups the count per month receved and I have other
columns that counts the approved date and completed date. What I am trying to
get is the % of the vales: #approved/#received, #completed/#approved.

Any ideas?
TIA
 
R

Roger Govier

Hi

Using the dropdown Pivot Table for the PT toolbar>Formulas>Calculated Field
Create a Name e.g. % App and in the Formula dialogue = Approved/Received
where Approved is the column heading of that date in your source data and
received is the column heading of received date in your source data.
Set the format of the field to be Percentage
Repeat for your other measure
 
C

Candyman

beacause the original design was based on the existence of a date, I reated a
few more columns and if(received_date,1,0) formula for the two fields. then
I simply used the Approved/received method as mentioned below.
Thanks
 
Top