General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
Hello.
I've created a pivot table just to display the away teams played by the home team - the score and my ratings for both teams. However in some of the leagues Iam covering the teams play each other three or four times in a season.
At the moment the Pivot table will total all the games of say Celtic at home to Rangers and display totals - I can click on the expand button and see each individual game, but this ruins the at a glancability of the thing and that was the purpose of creating it.
Is there any way of getting the Pivot Table to show all the Celtic v Rangers games as individual matches with no total line.
Thanks in advance.
Roman Totale father of Joe
I've created a pivot table just to display the away teams played by the home team - the score and my ratings for both teams. However in some of the leagues Iam covering the teams play each other three or four times in a season.
At the moment the Pivot table will total all the games of say Celtic at home to Rangers and display totals - I can click on the expand button and see each individual game, but this ruins the at a glancability of the thing and that was the purpose of creating it.
Is there any way of getting the Pivot Table to show all the Celtic v Rangers games as individual matches with no total line.
Thanks in advance.
Roman Totale father of Joe
Show More
There may well be a way.... could you cheat it by
1) Giving each match in your spreadsheet a match number (a2=a1+1 should be fine)
then 2) Using the pivot report filter to give Home=Celtic, Away=Rangers
3) Have the row labels as match number, so each match would be listed with the values you require (likely home goals and away goals only if I've understood you correctly)
You'd get something like
Home=Celtic
Away=Rangers
Row labels, home goals, away goals
5,345 1 0
12,555 2 1
33,192 3 0
44,401 0 2
Think that works, messy though it is to start with.
1) Giving each match in your spreadsheet a match number (a2=a1+1 should be fine)
then 2) Using the pivot report filter to give Home=Celtic, Away=Rangers
3) Have the row labels as match number, so each match would be listed with the values you require (likely home goals and away goals only if I've understood you correctly)
You'd get something like
Home=Celtic
Away=Rangers
Row labels, home goals, away goals
5,345 1 0
12,555 2 1
33,192 3 0
44,401 0 2
Think that works, messy though it is to start with.
*FWIW I'm terrible at excel so there's probably a one line answer.
Your first column of a table that you base your pivot table on needs to be unique values, so for the first column
it pays to have a sequence number.
When you do your pivot table in the row data box, put that sequence header in first then directly below
in the same box put in the team.
Alternatively before each team put in a number. ie ~ 1. Arsenal, 2. Arsenal. If your table has too many entries
to do that manually use a helper column to concatenate the sequence number to the teams.
it pays to have a sequence number.
When you do your pivot table in the row data box, put that sequence header in first then directly below
in the same box put in the team.
Alternatively before each team put in a number. ie ~ 1. Arsenal, 2. Arsenal. If your table has too many entries
to do that manually use a helper column to concatenate the sequence number to the teams.
Thanks for that.
I was inspired to make a work around based on CM's final suggestion.
I was inspired to make a work around based on CM's final suggestion.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539