Hi Folks,
Need help on the Pivot setting or option I can use to allow me show the percentage of TRUE on the column from each month see sample result below.
RAW Worksheet
<tbody> </tbody>
PIVOT WORKSHEET
<tbody>
</tbody>
What is the options I need to consider in the VALUE SETTINGS.
Appreciate your help in advance.
Thank you
Need help on the Pivot setting or option I can use to allow me show the percentage of TRUE on the column from each month see sample result below.
RAW Worksheet
A | B | C | D | |
1 | DateM | SLA Met | ||
2 | Sep | TRUE | ||
3 | Sep | TRUE | ||
4 | Sep | TRUE | ||
5 | Sep | TRUE | ||
6 | Sep | FALSE | ||
7 | Sep | TRUE | ||
8 | Sep | TRUE | ||
9 | Sep | TRUE | ||
10 | Sep | TRUE | ||
11 | Sep | TRUE | ||
12 | Aug | TRUE | ||
13 | Aug | TRUE | ||
14 | Aug | TRUE | ||
15 | Aug | TRUE | ||
16 | Aug | TRUE | ||
17 | Aug | TRUE |
<tbody> </tbody>
PIVOT WORKSHEET
A | B | C | D | |
1 | Month | SLA Met | ||
2 | Aug | 100% | ||
3 | Sep | 90% | ||
4 | ||||
5 |
<tbody>
</tbody>
What is the options I need to consider in the VALUE SETTINGS.
Appreciate your help in advance.
Thank you