9 Replies Latest reply: Nov 6, 2017 3:08 PM by Sunny Talwar RSS

    Create a variable for previous month

    Filiberto Cacciari

      Hi guys,

       

      that's my point. I'd like to create a table dipendent from two field of Date.

      The first one is the month of the value aggregation and the second one is a condition.

       

      I attach here what I'm looking for in excel example.

       

      This is the final target table.

       

          

      Jul-17Aug-17Sep-17Oct-17
      36501412


      Thank you so much.

       

      Filiberto

       

      stalwar1

      gwassenaar