Add % formula based on value

britknip

I am beyond stuck on this formula. I need to add columns with this formula

I have attached my sample that shows what I am trying to do.
'Data' tab is my current output

'Final' tab is what I am trying to get.

Need each row (and each column) to take that number divided by the net sales number. For that month only.

FS Lines_Example.xlsx

danrh

Give this a go:

Transpose so all your relevant values are in a single column, add a field through a Join to get the Net Sales amount on every line, perform the percentage calc, then do a pair of Crosstabs to get it back to the original format.  I haven't formatted the percentage fields in case you're going to do further calculations.  If that's not a need, you can play around with the Formula tool to get them in the right format.

Good luck!

solution.yxmd