#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Does this help you?
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create PIVOT chart using few rows in pivot table | Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
Pivot Table Question- Can the table display in the order the boxes were checked/selected? | blackjack | Excel | 0 | 09-13-2014 08:57 PM |
Pivot Table issue | ominae | Excel | 1 | 07-18-2014 01:40 AM |
Grouping Dates in Excel Pivot Table | mskennedy | Excel | 2 | 02-27-2013 11:09 AM |
Pivot Table Issue | Grovesy | Excel | 0 | 10-28-2012 09:08 PM |