Pivot Table total for rows by year

[MikeJones]

I am wishing to get a pivot table to show the totals for the years.

For example, I can get my pivot table to show the monthly values.  However, I wish to get the annual totals as the end of the pivot as shown below.

	Jan-21	Feb-21	Mar-21	Jan-22	Feb-22	Mar-22	2021	2022
Mike	10	15	10	5	10	15	65	30
Joe	20	30	40	60	60	60	270	180
Gill	36	40	60	70	70	70	346	210
Brandon	50	50	50	100	100	100	150	300

[martinpohl]

Hello,

so you need to create a special calendar.

The field from your normal calendar (Jan-21) = the month himself (Jan-21)

also the month = year

load

Monthname,

Monthname as MonthYear

resident Calendar.

load

Monthname,

Year as MonthYear

resident Calendar.

The user MonthYear as dimension in your pivot.

Regards