Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help with this tricky situation that I have. I have a request from finance to put the following information into a line chart. They want me to compare the 2013 vs 2012 by month for the last column in the attached screenshot. Basically I'm dividing our Inventory $ by the sum of the last 12 months of Sales. The formulas that I am using work great in a straight table, but not at all in the line chart. Can anyone offer any assistance?
Thank you!
I can provide some data for testing