kingspur06
Board Regular
- Joined
- Apr 24, 2007
- Messages
- 50
Hi Guys,
I have searched for the answer with no success so here goes.
I have a spreadsheet which I am using to record the bets I place (Don't do it- costs lots of money!)
Anyway, I have one column which is called "Confidence" and is a percentage figure which shows how confident I am that the bet will succeed.
I then have a 'result' column which shows whether I "Win" or "Lose".
I want to create a pivot table which will show how many times I won when confidence was between 0-20%, 21-40% etc etc.
How do I group the percentages together. At the moment it just shows every individual percentage figure as a different line on the pivot table.
I know I can manually group a selection on the Pivot Table itself by selecting the relevant data and clicking 'Group' but I would like to find a way of excel recognising which data needs to go into which group so that as I add more data and more percentages, the pivot table automatically updates them into the correct group.
many thanks for your help on this.
I have searched for the answer with no success so here goes.
I have a spreadsheet which I am using to record the bets I place (Don't do it- costs lots of money!)
Anyway, I have one column which is called "Confidence" and is a percentage figure which shows how confident I am that the bet will succeed.
I then have a 'result' column which shows whether I "Win" or "Lose".
I want to create a pivot table which will show how many times I won when confidence was between 0-20%, 21-40% etc etc.
How do I group the percentages together. At the moment it just shows every individual percentage figure as a different line on the pivot table.
I know I can manually group a selection on the Pivot Table itself by selecting the relevant data and clicking 'Group' but I would like to find a way of excel recognising which data needs to go into which group so that as I add more data and more percentages, the pivot table automatically updates them into the correct group.
many thanks for your help on this.