2 Replies Latest reply on Mar 26, 2020 9:20 AM by Krishna DW Branched to a new discussion.

    Index ()  Cal Issue

    Krishna DW

      Hello,

      I am trying to get index to each value based on Category column. Here is the example am trying to use

      three values here in category column are

      IT

      EEE

      CSE

      and made index compute using Category column and my expectation here is

       

      Category        Index along Category

         IT                   1

         EEE               2

         CSE               3

        

         but am getting it different as below

      Please let me know what am I missing here

       

      Also attaching 2019.2 workbook for reference.

       

      Thanks

      Krishna