2 Replies Latest reply on Dec 14, 2016 12:24 PM by Jaime Lego

    Renumbering dates to start at first week of sales

    Jaime Lego

      Hello,

      I have been working on this problem for quite some time, so I'd appreciate any help.

      I have sales of a product that starts on different weeks depending on the territory. I'd like to even out the sales so that the first week for each territory is week #1 (the orange bars below). Then the weeks after that would continue as week 2, week 3, etc.

      The only fix I've come up with is manually numbering the weeks within my data source. I'd like to come up with a formula that disregards the weeks preceding the first week of sales and then continues numbering the weeks from there.