I am new to pivot tables. I need to be able to import data for a fiscal year. thats easy right. but i have to compare month for month with previous year. I am unable to group it by
july 2018 | july 2019 | july 2019 - july 2018 | (july 2019 - july 2018) /july 2018 | aug 2018 | aug 2019
As you can see int the pivot table it brings data only as
july 2018 | july 2019 | aug 2018 | aug 2019
And by adding a calculated field it appears after each column, and not after month rage to do the calulations for each diff month.