Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-08-2016, 10:31 AM
salse salse is offline Pivot table dates issue Windows 10 Pivot table dates issue Office 2016
Novice
Pivot table dates issue
 
Join Date: Jun 2016
Posts: 3
salse is on a distinguished road
Default 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!
Attached Files
File Type: xlsx Book1.xlsx (13.5 KB, 9 views)
Reply With Quote
  #2  
Old 06-08-2016, 12:23 PM
xor xor is offline Pivot table dates issue Windows 10 Pivot table dates issue Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Does this help you?
Attached Files
File Type: xlsx PT_Dates.xlsx (18.5 KB, 10 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table dates issue 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 dates issue Pivot Table issue ominae Excel 1 07-18-2014 01:40 AM
Pivot table dates issue 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft