Apex Code Development You need to sign in to do that
Don't have an account?
p PILLI Matrix report Formula required
Hi I have a Field named ASAT, which is an Picklist, which shows Excellent, Average, Poor Against in row wise in Matrix against the Column values: Service Product Category ( Ex: General Enquiries, Online Shop etc.,)
When i see the matrix, its showing record count 5 and the Category Level 1 value as below screenshot:
I need to write the Formula for each record count+Category Level 1 in (Row Wise) against the Grand Total of all the Record Count.
Ex: Excellent has 7 while total Value is 12. Now we need to find Percentage as shown in Screenshot ( 7/12) *100 against each ASAT.
When i see the matrix, its showing record count 5 and the Category Level 1 value as below screenshot:
I need to write the Formula for each record count+Category Level 1 in (Row Wise) against the Grand Total of all the Record Count.
Ex: Excellent has 7 while total Value is 12. Now we need to find Percentage as shown in Screenshot ( 7/12) *100 against each ASAT.
You can check with below formula
Refer below link for similar discussion.
https://success.salesforce.com/answers?id=90630000000gprVAAQ
Best Regards,
Sandhya