Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Dates in a Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Dates | Excel Worksheet Functions | |||
Pivot Table Dates | Excel Discussion (Misc queries) | |||
Pivot Table Dates | Excel Discussion (Misc queries) | |||
Pivot Table Dates | Excel Discussion (Misc queries) |