A
Ajay
Morning All
I have a pivot table formatted as below:
Company Business Unit Calibration Result Count
ABS 123 Pass
6
Fail
30
123 count
36
The table contains approx 30 Companies with 3 -4 Business units assoc with
each.
The question is can I format the count column to show the count pass / fail
rate as a percentage of the subtotals for each Business Unit
ie in the example above Pass 6 = 16.66% and Fail 30 = 83.33%
Any help would be much appreciated
Cheers
Ajay
I have a pivot table formatted as below:
Company Business Unit Calibration Result Count
ABS 123 Pass
6
Fail
30
123 count
36
The table contains approx 30 Companies with 3 -4 Business units assoc with
each.
The question is can I format the count column to show the count pass / fail
rate as a percentage of the subtotals for each Business Unit
ie in the example above Pass 6 = 16.66% and Fail 30 = 83.33%
Any help would be much appreciated
Cheers
Ajay