Group Data in Pivot Table

[kingspur06]

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.

 

[PCL]

Perhaps you could add in the DataBase a filed to evaluate the condidence level:
0 for 0-20%
1 for 21-40%
Then add this field in the Pivot Table.
Of course this extra field could be calcualted IN the Pivot Table: