Skip to main content
Question

Pivot Table area options

  • June 17, 2020
  • 1 reply
  • 9 views
V
Level 0
Hi all. Is there an option to format the 1st column in a Pivot Table (dimensions) ? When it comes to drill down to more dimensions or the text in one dimension is > 25 characters is not readable (e.g. using small size 13px)

1 reply

C
Level 0
Hi! welcome to the Celonis Community! If I understand you correctly, I would suggest to create the first dimension dynamic with the help of a variable. You can create a new variable for each dimension you have and then create a button dropdown which writes the code of the dimensions to each variable. Then in the OLAP you can type the variable in the code (<%=yourvariable%>) as the dimension (first column). Now the User can select the dimension of choice in the buttom dropdown and it will dynamically be the first column of you OLAP. Hope this helps! Best Regards, Data Science Team
Community Code of ConductAccessibility statement