3 Replies Latest reply on Jan 18, 2019 4:04 AM by Jim Dehner

    Compare group with part of group

    Andreas Hagström

      Hi.

       

      I have one dimension called "CATEGORY" where our different business areas are separated. Then I have another dimension where all our customers are separated "NAME", all these customers belong to a category.

       

      I would like to group all the customers so I get a comparison group. Then I would like to be able to pick one customer in this group and compare to that group so I see how it compares to the average in that business area. But if I filter to a customer the comparison group also is only that customer for obvious reason.

       

      I also want the report to be dynamic so I can change customer and also category

       

      Example attached for easier understanding;

       

      Here I would like to be able to compare All customers in category A as a comparison group with one of the customers (NAME) in CATEGORY

       

      CATEGORYNAMESales
      A1564654
      A21861
      A351658
      A4681
      B5186818
      B65156186
      B73246