View Single Post
 
Old 12-16-2023, 03:24 PM
maw444 maw444 is offline Windows 10 Office 2019
Advanced Beginner
 
Join Date: Feb 2021
Posts: 35
maw444 is on a distinguished road
Default 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
Reply With Quote