• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 468
  • Last Modified:

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

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
JCTDD
Asked:
JCTDD
1 Solution
 
terencinoCommented:
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now