I have a simple OLAP Table. I want to put a percent column (in yellow below) to identify how many the column "Qty.Order Iitem" represents on Total. How can I calculate this percent?

Hi Claudio,

This can easily be achieved via the setting 'calculate share in percentages' in the data series setting, see the last section of https://help.celonis.cloud/help/display/CIBC/Formula+Editor for a clear example. I often include this as a 2nd KPI column in my tables, similar to your screenshot.

Good luck! Regards,

Lucas

Hi Lucas!

I used the formula below in the 2nd KPI column and it's work:

COUNT_TABLE("EKPO") / GLOBAL (COUNT_TABLE("EKPO"))

Thanks for your help!

Regards!