1 of 1 people found this helpful
Please see the attached workbook. In it we are able to take the % of total by each column (each month year combination) and then using that value build a % change table calculation that runs across the table instead of down it.
In a nutshell the % of total runs one way (down) the table and it runs first. Then we make another calculation that runs across and it is the % change of the % of total. I'm happy to explain in more detail if you like, also in the excel sheet the % change at the end you didn't subtract 1. Initially it gave me a scare because the numbers were seemingly funky. I've built the calculation that it accounts for 0s as well as nulls and used the absolute value of the denominator.
Thanks Carl, that worked great!