| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Countdown
Hello! Very good luck here in the past...hoping for a repeat!
I have a pivot table showing the count of facility audits on schedule for 2008 by type. On a different worksheet (same book) I have the detail to which staff will be referring when planning their schedules. I have a column for them to enter the date, once completed. Is their a way to make the pivot table to subtract one (1) from the total count each time a date is entered in the "Date Completed" field so that shows a true count of remaining audits? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table Countdown
Hi Daniel
Why not add another column to your source table for the PT, titled Audits Completed. Use some form of Lookup to populate this column from the data on "your different worksheet". Add a Count of Audits Completed to the PT, then you will see both. -- Regards Roger Govier "Daniel A." <Daniel wrote in message ... Hello! Very good luck here in the past...hoping for a repeat! I have a pivot table showing the count of facility audits on schedule for 2008 by type. On a different worksheet (same book) I have the detail to which staff will be referring when planning their schedules. I have a column for them to enter the date, once completed. Is their a way to make the pivot table to subtract one (1) from the total count each time a date is entered in the "Date Completed" field so that shows a true count of remaining audits? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table Countdown
Good suggestion! Thanks...
"Roger Govier" wrote: Hi Daniel Why not add another column to your source table for the PT, titled Audits Completed. Use some form of Lookup to populate this column from the data on "your different worksheet". Add a Count of Audits Completed to the PT, then you will see both. -- Regards Roger Govier "Daniel A." <Daniel wrote in message ... Hello! Very good luck here in the past...hoping for a repeat! I have a pivot table showing the count of facility audits on schedule for 2008 by type. On a different worksheet (same book) I have the detail to which staff will be referring when planning their schedules. I have a column for them to enter the date, once completed. Is their a way to make the pivot table to subtract one (1) from the total count each time a date is entered in the "Date Completed" field so that shows a true count of remaining audits? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Linear Mode
