[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 466
  • 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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