Pivot table dates issue
Hi,
I've got a set of data with start and end dates. I'm looking to create a pivot table and ultimately a chart that shows month by month how many plans started and how many ended.
Take a look at the attached worksheet, its correct showing that 5 plans started in August and one in september, yet it's showing that 4 ended in august and none in september when it should be 3 ending in august and 1 in september.
Thanks for your help!
|