We are trying to create a report which shows contract information with different validities. I can see the information in rows but ideally need them shown in columns.
Layout in rows means I have 8 rows for 8 different validities but in columns this would reduce the number of rows massively
Not sure I understand you, my apologies.... Do you mean having the values of validities shown as "columns" (ie dimensions or kpi) in a OLAP table? and one row per contract?
Not sure I understand you, my apologies.... Do you mean having the values of validities shown as "columns" (ie dimensions or kpi) in a OLAP table? and one row per contract?
Hi Guillermo,
we have an Excel file which shows one row for the contract and then in columns the price information.
When we try to replicate this into Celonis I get one line per price and validity. So I was wondering if there is a way that I have one line per contract and then the pricing information for the different validities in the columns so like the Excel at the top
The issue is that we have lots of material numbers so we get 1000s of lines and due to this it does get hard to read.
Hope this helps
Hi Guillermo,
we have an Excel file which shows one row for the contract and then in columns the price information.
When we try to replicate this into Celonis I get one line per price and validity. So I was wondering if there is a way that I have one line per contract and then the pricing information for the different validities in the columns so like the Excel at the top
The issue is that we have lots of material numbers so we get 1000s of lines and due to this it does get hard to read.
Hope this helps
Not sure if it will work, but try to put all the columns describing the contract as a KPI, not as Dimension.... by default, Celonis will group the KPIs per dimension, so if you have as dimension contract number and material number... then you will have one line per combination.
If I can I will try to do it in my environment.no promises, though
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
