Pivot Table Fiscal Years

G

Guest

My pivot table groups data by calendar year. Can I make it group data by my
fiscal year (Dec - Nov) instead? I want to end up with a column for each of
my 3 fiscal years rather than 3 calendar years.

Many thanks
 
G

Guest

A simple way to add a fiscal year column in the database to convert the
calendar year to Fiscal year. if you have a date field you can use this
formula to convert calendar to fiscal year
"=IF(MONTH(E4)=12,YEAR(E4)+1,YEAR(E4))" where E4 should be the calendar date
field. This fiscal year column could be added on the pivot table
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top