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
|