We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
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
sort by:
Show
per page
Replies: 4
|
By:
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. |
|
By:
*FWIW I'm terrible at excel so there's probably a one line answer.
|
|
By:
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. |
|
By:
Thanks for that.
I was inspired to make a work around based on CM's final suggestion. |