3 Replies Latest reply: Jul 18, 2017 7:21 AM by Graeme Smith RSS

    Group measures Pivot Table

    Johann Bauer

      Hi Guys,

      im having a pivot table with 9 calculated Measures. I want to group these measures into 3 different groups, like in this picture.

      I know that I have to add some Dimension or Measure to the Columns. But im not sure how I group them correctly. Because there is no logical relation between these measures

      Pivot.png

      KR,

      Johann

        • Re: Group measures Pivot Table
          Graeme Smith

          There are different ways of tackling this, but the simplest (and assuming your data model isn't too large / complex, I would go with something like this - data islands can have impacts on caching and performance for very large applications, but I won't go into it here):

           

          Load Script:

           

           

          Sales:

          Load * Inline [

          Customer,RevenueMTD,RevenueYTD,ProfitMTD,ProfitYTD

          X,10,100,1,11

          Y,20,200,2,21

          Z,30,300,3,31

          ];

           

           

          Expressions:

          Load * Inline [

          ExpressionID,ExpressionGroup,ExpressionName

          1,MTD,MTD Revenue

          2,MTD,MTD Profit

          3,YTD,YTD Revenue

          4,YTD,YTD Profit

          ];

           

           

          Chart Expression:

          Pick(ExpressionID, Sum(RevenueMTD), Sum(ProfitYTD), Sum(RevenueYTD), Sum(ProfitYTD))

           

           

          18-07-2017 10-10-26.jpg