Solved

excel 2010 pivot table seperate data between month and yeat-to-date

Posted on 2013-01-07
1
454 Views
Last Modified: 2013-04-07
based on the attached file I have Month data and year to date data in a table.
I need to create a pivot table that will show the month data and year to date data in seperate columns.

I cannot get it to work so was hoping you could help?
Book1.xlsx
0
Comment
Question by:JCTDD
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 16

Accepted Solution

by:
terencino earned 500 total points
ID: 38754013
Hi JCTDD yes this is hard to get working as you want, I usually add another column for the current period, as I have shown attached, and also define a Current named range for the last day of the current month.
Let me know what you think
...Terry
Pivot-YTD.xlsx
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question