Hi, I have a source data which I can't change because if I add a column with a formula, it will make the file that much heavier.
I'd like to calculate a simple ratio of calculations. Here's a simulated example of what I'd like.
<tbody>
</tbody>
Basically, I want a calculated field of a ratio of i/j:
i =being a countifs of all the AB and Yes1, Yes2, Yes3
j = being a countif of all the AB.
It would be easy by adding a new column, but I can't. I thought that it would be possible with a calculated field in a pivot table, but I can't find the option to do what I want. Any help would be appreciated.
I'd like to calculate a simple ratio of calculations. Here's a simulated example of what I'd like.
Column A | Column B |
AB | Yes1 |
AB | No |
EF | - |
CD | - |
AB | Yes2 |
CD | - |
AB | Yes3 |
AB | No |
AB | Yes1 |
<tbody>
</tbody>
Basically, I want a calculated field of a ratio of i/j:
i =being a countifs of all the AB and Yes1, Yes2, Yes3
j = being a countif of all the AB.
It would be easy by adding a new column, but I can't. I thought that it would be possible with a calculated field in a pivot table, but I can't find the option to do what I want. Any help would be appreciated.