2 Replies Latest reply on Feb 8, 2018 3:40 PM by Zhouyi Zhang

    Summing same cohort across months

    m b

      Hi. I have two categories of people; Rookies and Experienced. Rookies are <12 months in tenure. I'd like to see the sum of the Rookie group of sales over the last year.

      The problem is if I set it up normally I see only the sales of those who are Rookies today. But what I really want is to see the sales of the Rookie group in each month over the last year - and the Rookie group changes each month, some get added as brand new and others drop off because they're >12months.

       

      So how can I see the actual Rookie group sales for each particular month? I'm thinking something with an LOD formula where the Month is fixed... but can't get it to work.