1 Reply Latest reply: Sep 24, 2018 7:33 AM by Ruben Marin RSS

    Measure by dimension

    Daniel Rodríguez

      Hi all

       

      I'm facing the following issue: I have a table with 3 kinds of information

      TotalTypeType2
      1

      A

      A.1
      2AA.2
      1B
      3B
      1C
      6C

       

      and I'm trying to build the following pivot table:

       

      sum (Total) where type=Asum (Total) where type=Bsum (Total) where type=C
      A.1

      1

      47
      A.2247

       

       

       

      Is there a way to do that?

       

      Thanks in advance

       

      Regards

        • Re: Measure by dimension
          Ruben Marin

          Hi Daniel, as Type2 is not related to all records you can use TOTAL qualifier to avoid dimension values, and apply set analysis to filter by Type.

           

          Using Type2 as dimension and 3 expressions/metrics:

          - Sum({<Type={'A'}>} Total)

          - Sum(TOTAL {<Type={'B'}>} Total)

          - Sum(TOTAL {<Type={'C'}>} Total)


          Naming a field 'Total' can make diffficult to different the qualifier TOTAL and the field Name.