Need to achieve this below report along with the percentage.

[kiran115]

I have a requirement to fetch records showing both breached and non-breached RITMs.
My goal is to calculate the RITM Success Percentage, which is defined as:

(Not Breached = false / Total Count) × 100

However, in regular reporting using Multi-Pivot, the Functional Field option is disabled, so I’m unable to perform this calculation there.

Could anyone please suggest how to achieve this in Performance Analytics (PA) or share an alternate way to calculate and display this percentage?
If it’s achievable with PA, what would be the best way to visualize it (e.g., Scorecard, Pivot Table, Breakdown, etc.)?

Example output:

Item Owner	Total Count	Breached = false	RITM Success %
User 2	19	15	78.9%
User 1	1309	933	71.3%
User 3	2	1	50%

[AndersBGS]

Hi @kiran115 ,

Quite easy in PA - but sounds like you're not expired in using PA? If that is the case, I would recommend that you take the official training, as if you do it wrong you can create a heavy load on the platform.