Pivot table group by year . Define year start and end

		Microsoft Office Forums > Microsoft Excel > Excel
Pivot table group by year . Define year start and end

FAQ

Thread Tools

Display Modes

12-16-2023, 03:24 PM

maw444

Windows 10 Pivot table group by year . Define year start and end

Office 2019

Advanced Beginner

Join Date: Feb 2021

Posts: 40

Pivot table group by year . Define year start and end

I have a dataset which lists the value at the end of each month.

I want to find the average of the month end total on annual basis

I can do that but it defines the year as Jan to Dec

Is there a way to tell Excel that the year start is April so it groups and averages on a April to March basis

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to search for a specific year from a table with year range?	Wii	Excel	0	05-05-2015 12:40 PM
How to calculate a rolling year-to-date percentage by quarter as the year progresses	sleake	Excel Programming	2	04-23-2015 11:51 AM
Networkdays per fiscal year in a 6 year range	jabnm	Excel	1	10-16-2014 11:51 AM
Year to Year in Fillable form	Lara	Word	1	04-09-2013 03:19 PM
Creative Ways for a year-to-year comparison???	ridonkulous5	Excel	1	03-23-2011 04:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:51 PM.