Pivot table formula with dates
 

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
--
In God we trust.

Pivot table formula with dates
 

Hi

Using the dropdown Pivot Table for the PT toolbarFormulasCalculated 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
--
Regards
Roger Govier

"candyman" wrote in message
...
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
--
In God we trust.

Pivot table formula with dates
 

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

"Roger Govier" wrote:

Hi

Using the dropdown Pivot Table for the PT toolbarFormulasCalculated 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
--
Regards
Roger Govier

"candyman" wrote in message
...
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
--
In God we trust.