Forum Discussion

Andres_Maldo's avatar
Andres_Maldo
Frequent Visitor
4 years ago
Solved

Grouping measures in a matrix

Hi, Guys. I have 4 measures (ROI, EBITDA, KPI 1, KPI 2) and I would like to classify in groups:   FINANCE: ROI, EBITDA SALES: KPI 1, KPI 2   And I woud like to get this matrix: I appreci...
  • Andres_Maldo's avatar
    Andres_Maldo
    Frequent Visitor
    4 years ago

    Hi, ALLUREAN.

    Thanks, but I have measures instead of columns. And I need to be measures. I am wondering is there is a way to group these measure in a matrix.

    • ALLUREAN's avatar
      ALLUREAN
      Icon for Solution Sage rankSolution Sage
      4 years ago

      I use your 4 measures into one, not columns

      • Andres_Maldo's avatar
        Andres_Maldo
        Frequent Visitor
        4 years ago

        Thanks, I see. That´s an interesting approach, but what if I want KPI1 as a decimal number, KPI2 as a whole number and ROI as a percentaje? And I want to use conditional formatting in just one measure?