2 Replies Latest reply on Sep 27, 2018 10:39 PM by Shinichiro Murakami

    I want to find out P3M,P6M and P12M for the current year and last year

    surya joseph

      Hi all

       

      I am new to tableau.Kindly help me.

       

      I have table which looks like below

       

      brand        yearmonth     profit

      A                201601          10

      B                201601          7

      C                201601         11

      A                 201602         22

      B                201602          11

      C                201602           34

      A                 201603       22

      B                201603          11

      C                201603           34

      A                 201604        22

      B                201604          11

      C                201604           34

      .................................................

      .................................................

      .................................................

      .................................................

       

      I want to calculate the sum of profit for the past 3 months for each brand(for brand A,want to sum up 4th ,3rd,2nd month profit)Note that the year month column is an integer.

       

      Kindly help.....