3 Replies Latest reply on Apr 19, 2018 1:08 AM by Lohan le Roux

    Dense Rank Per Customer ID

    Lohan le Roux

      Hi Everyone,

       

      I have a scenario which should have a simple solution but i'm struggling a bit to find it.

      I want to group by a Customer ID and Count the Trand ID (Both are distinct) to get the Required Column below.

       

      Tran IDCustomer ID Required
      111
      212
      313
      414
      515
      616
      721
      822
      923
      1024

       

      The issue is if I use { FIXED [Customer Id]: COUNTD([Tran Id])} I get the answer below.

       

      Tran IDCustomer ID        
      116
      216
      316
      416
      516
      616
      724
      824
      924
      1024

       

      Any help will be appreciated.