5 Replies Latest reply on Nov 8, 2018 2:37 PM by Deepak Rai

    FIXED LOD (COUNTD) behavior with Hierarchy

    Sagar Kavitake

      Hi All,

       

      I have a FIXED LOD calculation but I expect it to change based on the hierarchy expansion.

      I have a hierarchy with two levels Name and Place.

      The Ids for Direct Ad|Trip1 and Direct Ad|Trip2 are same except one (68417298) highlighted below.

       

      img1.png

      Now, I want to get a DISTINCT count of ([Id]).

       

      1. At Name level, I wish to get it as 6.

      2. At Place level, I wish to get it as 6 for trip1 and 5 for trip2.

       

      I can get both these to work but separately

       

      #1 LOD Fixed by Name (Denominator)

      Img2.png

      #2 LOD Fixed by Name & Place (Denominator)

      Img3.png

       

      How can I accomplish both in a single calculation?