Thanks for posting a packaged workbook and the Excel spreadsheet, the only bit of confusion I had was with different field names between the two. I think I've got what you want set up in the attached, there were a few steps:

- Turn the % Sales Growth quick table calc into an actual calculated field so we can use it in the Evolution Index calc.

- Build the % Market Growth calc. This is a nested table calculation, where there's a Total Sales per Year with a Compute Using of Company (so it partitions on date to generate the same total that we see in the Grand Total row), then a % Market Growth calc with a Compute Using of Date.

- Then build the Evolution Index Calc using the formula, and once the EI pill is in the view verifying that the nested Compute Using is working accurately.