Changing pivot table values from % of row total to implied odds

[mazdaq100]

I have a pivot table setup as below, which currently shows, in each football season, how many times a certain number of cards has been awarded in a football match. The results are presented as a percentage of the row total. I want to change this so they are presented as the implied odds of each outcome occurring. To do this, the calculation required is 1/"percentage value". However, how do I actually get the pivot table to display this?

Count of Total cards

Column Labels

Row Labels

0​

1​

2​

3​

4​

5​

6​

7​

8​

9​

10​

11​

12​

13​

14​

15​

16​

Grand Total

2013/14

1.05%​

3.68%​

5.53%​

9.74%​

17.63%​

13.16%​

18.95%​

8.16%​

10.26%​

5.53%​

2.63%​

2.37%​

0.79%​

0.53%​

0.00%​

0.00%​

0.00%​

100.00%​

2014/15

1.05%​

2.37%​

6.58%​

11.58%​

12.37%​

13.42%​

13.42%​

11.32%​

12.37%​

6.84%​

3.95%​

2.63%​

1.32%​

0.53%​

0.26%​

0.00%​

0.00%​

100.00%​

2015/16

0.53%​

2.11%​

5.26%​

7.89%​

17.11%​

14.47%​

16.58%​

12.89%​

7.89%​

8.42%​

2.11%​

1.32%​

2.11%​

0.79%​

0.53%​

0.00%​

0.00%​

100.00%​

2016/17

0.26%​

3.42%​

6.84%​

10.26%​

14.74%​

16.84%​

16.84%​

10.53%​

10.79%​

4.74%​

2.37%​

1.84%​

0.00%​

0.00%​

0.53%​

0.00%​

0.00%​

100.00%​

2017/18

0.79%​

3.42%​

9.21%​

13.16%​

14.21%​

17.37%​

13.68%​

9.21%​

7.11%​

3.16%​

3.16%​

1.05%​

2.11%​

0.26%​

1.32%​

0.26%​

0.53%​

100.00%​

2018/19

0.26%​

3.68%​

5.79%​

11.84%​

16.84%​

15.00%​

13.16%​

11.32%​

8.95%​

5.26%​

2.37%​

2.63%​

1.84%​

1.05%​

0.00%​

0.00%​

0.00%​

100.00%​

2019/20

0.45%​

4.09%​

5.45%​

10.91%​

14.55%​

15.91%​

13.18%​

12.73%​

5.00%​

8.18%​

6.82%​

0.91%​

1.36%​

0.45%​

0.00%​

0.00%​

0.00%​

100.00%​

Grand Total

0.64%​

3.20%​

6.44%​

10.76%​

15.40%​

15.12%​

15.24%​

10.76%​

9.16%​

5.88%​

3.12%​

1.88%​

1.36%​

0.52%​

0.40%​

0.04%​

0.08%​

100.00%​

For example, if we take the 2018/19 season, the implied odds of 6 cards being awarded in the game = 1/.13.16 = 7.60

I have a workaround where in a cell outside the pivot table, I just have a formula =1/"cell value" = 7.60. However, is there a way of presenting the same value in the pivot table?

 

[cyrilbrd]

Hi,
Pivot table Values allows you to display sum, count, max, min, variance, average... but not text.
Your result here will be treated as a text.
You could have opted to format as a fraction but it seems that is not what you required.