Skip to main content
Question

Transpose of Pivot Table/ OLAP Table

  • March 24, 2022
  • 1 reply
  • 45 views
S
Level 1
Forum|alt.badge.img+7

I have a requirement to display 3 KPIs as rows and their respective values across each month as columns. In Celonis 4.7, I can define multiple KPIs but can select only one KPI to display. And this KPI is also displayed as vertical. is there an option to display multiple KPIs horizontally ?

      1 reply

      L
      Level 0
      Forum|alt.badge.img+6
      • lea.hanna12
      • Level 0
      • March 4, 2024

      Hello Sundareswaran, 

      Only one KPI can be shown in the pivot table , you can define many KPIs but can only display one. However, if you would like to display your KPI horizontally, in the component options of the pivot table you can press ‘Show KPI Summary’ under ‘advanced options’ which will then show a sum of all the rows in terms of your KPI. 

       

      For more detailed information on this please refer to this documentation: https://docs.celonis.com/en/pivot-table.html

       

      Hope this is helpful,

      Thank you for your question!

      Community Code of ConductAccessibility statement