1 Reply Latest reply on Nov 7, 2018 2:12 PM by Patrick A Van Der Hyde

    sum of profit for P3M,P6M,P1Y and percentage difference vs last year

    surya joseph

      Hello All,

       

      I am new tableau.Am stuck with my requirement.Kindly help me as soon as possible.

      Here is  my problem

       

       

      ProductprofitDate
      A234201601
      A100201602
      A123201603
      A3201604
      A3201605
      A3201606
      A44201607
      A 201608
      A444201609
      A55201610
      A33201611
      A44201612
      B234201601
      B100201602
      B123201603
      B3201604
      B3201605
      B3201606
      B144201607
      B1222201608
      B1444201609
      B55201610
      B133201611
      B144201612
      A234201701
      A100201702
      A123201703
      A3201704
      A3201705
      A3201706
      A44201707
      A2201708
      A444201709
      A55201710
      A33201711
      A44201712
      B234201701
      B100201702
      B123201703
      B3201704
      B33201705
      B43201706
      B3144201707
      B1222201708
      B1444201709
      B355201710
      B133201711
      B2144201712
      A1111201801
      B3423201801

       

      I want to display the data in a cross tab which is attached with this.

      if the value in the percentage diff column is null then replace with -.

       

      Any help is appreciated.Please note that dateparse function is not supported.

      TIA