I have a base data field:
Presenting Complaint | Diagnosis complaint a | <blank> complaint b | diagnosis a complaint c | diagnosis b
I have a pivot table:
Presenting complaint | Count of diagnosis | Count of presenting complaint complaint a | | 1 complaint b | 1 | 1 complaint c | 1 | 1
I want to create a custom field which basically counts percentage diagnosis made, taking account of the two calculated pivot fields ('count of diagnosis') and ('count of presenting complaint'). Is this possible?