I have a pivot table that counts the actions done by date.
EX:
On the worksheet there are 6 lines:HTML Code:
5/10/10 Paul Call
5/11/10 Paul Visit
5/1/10 Paul Visit
etc...
On the chart: Values = Date Count
This is continued throughout the month
I want to seperate the counts by weeks (have 4 charts that looks at the same input and displays the count for that week.
The problem: there are 20 people and potentially 800+ actions
What I have done:
Created the Pivot tables so they look right
On the Date, I Filtered each chart Between X date and x date
All the charts show the same result - coworker says it is because the counts are displayed not the dates.
Any Help appreciated.
Bookmarks