Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2013-01-07
1
Medium Priority
?
468 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
1 Comment
 
LVL 16

Accepted Solution

by:
terencino earned 2000 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

595 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