1 Reply Latest reply on Nov 14, 2017 10:48 AM by Martin van Donselaar

    Dense Rank in OBIEE

    DollyG

      Hi,

      Can anyone please help me in applying dense rank in obiee?

      I need to get data of top 3 dense ranks, so the result should display 4 rows in this case as rank 2 is shared by 2 products.

      For example, my table structure is:

      Products        Sales                Dense  Rank
      ABC                  10                     1
      XYZ                  20                     2
      AAA                  20                     2
      ZZZ                  30                     3
      DSE                 40                      4