Pivot Table Countdown

D

Daniel A.

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?
 
R

Roger Govier

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.
 
D

Daniel A.

Good suggestion! Thanks...

Roger Govier said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Calculations 2
Average of Subtotals in Pivot Table 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Excel Excel Show Countdown Date 7
Pivot table formulas based on text fields 3
grouping dates in a pivot table 1
Link Drop Down with Pivot Table 2
Problem if Source field name of pivot table changes 1

Top