Hi everyone,
I am trying to use a pivot table to initially analyze jockey stats and I am having difficulties in getting totals for different items.
What I am trying to produce is:
Name..Rides..Win................Place...............Show
Pardo 4 ........ 1 25% $4.00 2 50% $5.50 3 75% $ 6.60
The data column headers are:
Horse_Name, Finish, jockey, winpay, placepay, showpay
The data is:
Lone Boy 1 Pardo 4.00 3.00 2.00
Mary One 2 Pardo 0.00 2.50 2.10
Good Two 3 Pardo 0.00 0.00 0.00
Blackacre 4 Pardo 0.00 0.00 2.50
Obviously there are other horses, jockeys, races, etc.
I want to use a pivot table because I can filter the data by year, odds rank, odds, and other header labels. The original data set has about 100,000 lines of data and 80 columns.
I can get the total number of rides by counting on the jockey's name. The problem is breaking out the rides to reflect only a 1st, 2nd, and 3rd place finish and having the percentage relate back to the total number of rides. I have tried various filtering mechanisms and calculated fields without sucess.The problem is usually that the order of finishes gets lumped into the same number, so 1st, 2nd, 3rd are all the same numbers.
I am using Win 7 and Excel 2010.
Any suggestions would be greatly appreciated.
I have not posted before and I think I have included the information needed to solve the problem. If I have not, just let me know and I will include it.
Thanks in advance,
Jack
I am trying to use a pivot table to initially analyze jockey stats and I am having difficulties in getting totals for different items.
What I am trying to produce is:
Name..Rides..Win................Place...............Show
Pardo 4 ........ 1 25% $4.00 2 50% $5.50 3 75% $ 6.60
The data column headers are:
Horse_Name, Finish, jockey, winpay, placepay, showpay
The data is:
Lone Boy 1 Pardo 4.00 3.00 2.00
Mary One 2 Pardo 0.00 2.50 2.10
Good Two 3 Pardo 0.00 0.00 0.00
Blackacre 4 Pardo 0.00 0.00 2.50
Obviously there are other horses, jockeys, races, etc.
I want to use a pivot table because I can filter the data by year, odds rank, odds, and other header labels. The original data set has about 100,000 lines of data and 80 columns.
I can get the total number of rides by counting on the jockey's name. The problem is breaking out the rides to reflect only a 1st, 2nd, and 3rd place finish and having the percentage relate back to the total number of rides. I have tried various filtering mechanisms and calculated fields without sucess.The problem is usually that the order of finishes gets lumped into the same number, so 1st, 2nd, 3rd are all the same numbers.
I am using Win 7 and Excel 2010.
Any suggestions would be greatly appreciated.
I have not posted before and I think I have included the information needed to solve the problem. If I have not, just let me know and I will include it.
Thanks in advance,
Jack