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.
Solved! Go to Solution.
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!
Thank you, this worked great!