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

pivot table with a fiscal year cycle

I want to make a pivot table with 4 quarters but the 1st quarter starts Oct 1 not Jan 1st
how can I make the 1st quarter start in Oct

I have date format of mm/dd/yy and yyyymm
  • 2
1 Solution
Hi an option is to add another column in your data with a vlookup to a table which matches your period to a quarter, like attached
CRshieldAuthor Commented:
this might work

what about grouping months together and then labeling it? Saw it in a video lesson last night.

but I am not sure I can group more that 1 3 month period, can I?
Sure you can group months using the grouping function of the pivot table, and then you can manually relocate the quarter to suit the layout you want but it won't allow you to specify which months go in which quarter, since it is based on standard US calendar year fiscal periods. So it is better to customise.
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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