Contribution to Growth Help

Hi All,

This is what I have on my dashboard so far:

I'm trying to find the percent contribution of each item under grand total towards the grand total percent growth. In short, my new calculation should be called: "% contribution to growth". Basically, I need to find a way to multiply the NP6 Mix Count for 2018 by NP6 Growth between 2018 and 2019 (located in the 2019 column under NP6 Growth column). If anybody can helo me out that would be awesome.

This is the formula that I have so far: (sum([Np6 Count]) - lookup(sum([Np6 Count]), -1)) / total(sum([Np6 Count]))

but it gives me the incorrect result.

Thanks for your help!

My new column would look something like this:

Notice, these 4 percents all add up to 8.84% from the NP6 growth as a % contribution to overall grand total % growth. Thanks!