Calculating avg(win)/avg(loss) for grouped data in pivot

[michellepace]

Hi there,

As shown in the screenshot I am struggling to correctly calculated "Average(winning trade)/Average(losing trade) for grouped data.

Could anyone please provide suggestions on calc_RewardRatio.xlsx as to what I can be doing wrong?

screenshot.png

Thank-you
Michelle

[JeteMc]

It is not that you are doing something wrong, but that the pivot table doesn't understand what you are asking. By adding a formula, which may be copied down as far as needed, and applying format painter, you can produce a fake pivot table column that yields the desired values. The formula is:

Please Login or Register  to view this content.

Here is your file with the changes applied:
Copy of calc_RewardRatio-1.xlsx
Let me know if you have any questions.