Forum Discussion
Calculating Percentage of wins
I’m stumped here. Anyone know of a best practice way to do the following? I would like to have a column in which I can type a “W” or “L”. (Wins or Losses). Then I would like to have another colu...
Hello,
Using PivotTable is certainly your best option with regards to what you intend to achieve.
Once you insert your PivotTable, you can drag and drop that contain Win or Loss inside the value area. Again, drag and drop the field that contains Win or Loss into the value area. Then, right-click the second field and select Show Value as % of Running Total.
That will give you exactly what you want.
Cheers
Using PivotTable is certainly your best option with regards to what you intend to achieve.
Once you insert your PivotTable, you can drag and drop that contain Win or Loss inside the value area. Again, drag and drop the field that contains Win or Loss into the value area. Then, right-click the second field and select Show Value as % of Running Total.
That will give you exactly what you want.
Cheers