1 Reply Latest reply on Dec 18, 2017 10:34 AM by Hari Ankem

    How to get a column which is sequentially increasing based upon a condition ??

    arvind jain

      Hi All,

       

      I have a column  INDEX in my tableau work work book. Based upon Top in I have to create a calculated field which shows the number of project. so if there are n TOP in Index column then n project are available.

       

      Input    

       

      IDINDEX
      1TOP
      21
      32
      42
      53
      63
      74
      84
      9TOP
      101
      112
      122
      133
      143
      154
      16

       

      44

       

      Output

       

       

      IDFILTERINDEX
      1PROJ_1TOP
      2PROJ_11
      3PROJ_12
      4PROJ_12
      5PROJ_13
      6PROJ_13
      7PROJ_14
      8PROJ_14
      9PROJ_2TOP
      10PROJ_21
      11PROJ_22
      12PROJ_22
      13PROJ_23
      14PROJ_23
      15PROJ_24
      16PROJ_24