4 Replies Latest reply on Oct 24, 2018 4:38 AM by KHARANSU RATH

    Aggregation over Fixed LOD

    KHARANSU RATH

      Hi all,

      Suppose I have 4 locations like A, B, C and D and each has 3 distributors but when I further drill down, they have customers like

      "A.1" has 4, "A.2" has 5, "A.3" has 7

      "B.1" has  3, "B.2" has 8, "B.3" has 9

      Similarly take it for C and D locations.

       

      Now when I do the pivoting, I am getting the count at the least level, i.e, customer level.

      But I want another column where I can find the total count of all the customers for all the 4 locations individually at their levels.

      How would I get that to do the comparison? 

       

      Thank You.