4 Replies Latest reply: Mar 15, 2018 11:07 AM by Digvijay Singh RSS

    Help to create hierarchy field

    Michele De Nardi

      Hi experts,

      i've got a simple table like below where i've stored a list of numbers.

       

      Tab1:

      Number
      1
      2
      3
      4
      5
      6
      7
      8
      9

       

      I want to create one new field in order to use as filter where if i select:

      • "All numbers equal minors of 2" my Tab1 filters 1 and 2 numbers;
      • "All numbers equal minors of 5" my Tab1 filters 1,2,3,4 and 5; 
      • And so on

       

      How to achieve this by using an elegant solution ? Maybe hierarchy() function could be the correct way but i didn't understand how to write the code...

       

      Thanks