Possibility to create pivot view like in excel. KPI

I would like to calculate KPI for employees. I have several goals, each with a different importance, but I would like an example of at least 1.

Is it possible to get something like this at Zoho analytics?

I have Data Sources form Zoho Desk.

I would like create table in Analytics that can calculate KPI

I created the KPI calculation logic in Excel I would like to reproduce this in the report in Analytics

Another examples

In Zoho Analytics I create Pivot view that can calculate % of new ticket on the date of creation.