Assuming your Months are just text fields and not date fields, you should just be able to add YEAR as the second dimension in your pivot table. of course YEAR should be calculated in your calendar. it will then look like the attached
Your solution works but since months are calculated based on dates and it is a pivot table, I couldn't get value for previous year but previous year's months(Jan to Dec). May I know how to get previous year value in pivot table? Thank you.
not sure what the issue is. month and both years are at the top
and then add a %:
maybe you need to explain the requirements. its not easily discernible from your picture what numbers you need it sounds like you wanted months somewhere else but your picture shows it to be in the column not rows.
not sure what you mean by vertical - did you mean in the columns? and when you say year in the horizontal did you mean the rows as in dimensions?