2 Values on a PivotTable

[drom]

Hi and Thanks in Advance!

I have a Table on a WorkSheet containing the following headings:
A1="Year", B1="Winner's Country", C1="Winner", D1="Score", E1="runner-up's Country", F1="runner-up"

This is to show the information contained on the Web:
http://es.wikipedia.org/wiki/Liga_de_Campeones_de_la_UEFA
when you find the Word "Sede Final".

* * *
I am trying to create a Pivot Table to show the results the same way this webSite does when you find the Words "Lista de países con clubes finalistas" together

I am able to replicate the first to columns using as row labels ="Winner's Country" and Values="Winner"

But I am Not able to get the 3rd column, so how many times a Country has finished in second place on the right on how many times this country it's been the winner.
I guess you will understand better going to the WebSite and lookinf for:
"Lista de países con clubes finalistas"

Thanks!

 

[GlennUK]

You need to re-organise your data to get a PivotTable like that. Have a look at this:

Excel Workbook
	A	B	C	D	E	F	G	H
1	Year	Country	Team	Position	*	Count of Team	Position	*
2	1955/56	Spain	Real Madrid	Winner	*	Country	Winner	Runner up
3	1955/56	France	Stade de Reims	Runner up	*	Spain	13	9
4	1956/57	Spain	Real Madrid	Winner	*	Italy	12	14
5	1956/57	Italy	ACF Fiorentina	Runner up	*	England	11	7
6	1957/58	Spain	Real Madrid	Winner	*	BeNeLux	6	3
7	1957/58	Italy	AC Milan	Runner up	*	Germany	6	8
8	1958/59	Spain	Real Madrid	Winner	*	Portugal	4	5
9	1958/59	France	Stade de Reims	Runner up	*	France	1	5
10	1959/60	Spain	Real Madrid	Winner	*	Serbia	1	1
11	1959/60	Germany	Eintracht Frankfurt	Runner up	*	Rumana	1	1
12	1960/61	Portugal	Benfica	Winner	*	Scotland	1	1
13	1960/61	Spain	Barcelona	Runner up	*	Sweden	*	1
14	1961/62	Portugal	Benfica	Winner	*	Greece	*	1
15	1961/62	Spain	Real Madrid	Runner up	*	*	*	*
16	1962/63	Italy	AC Milan	Winner	*	*	*	*
Sheet30

Not that I can get it sort on Winner then Runner-up.

 

[GlennUK]

Or, you could have 2 pivottables from your existing table, and use formulas to create your desired output, like this:

Excel Workbook
	A	B	C	D	E	F	G	H	I
1							Country	Winner	Runner up
2							Spain	13	9
3	Count of Winner's Country			Count of Runner-up's Country			Italy	12	14
4	Winner's Country	Total		Runner-up's Country	Total		England	11	7
5	Spain	13		Italy	14		Germany	6	8
6	Italy	12		Spain	9		BeNeLux	6	3
7	England	11		Germany	8		Portugal	4	5
8	Germany	6		England	7		France	1	5
9	BeNeLux	6		France	5		Scotland	1	1
10	Portugal	4		Portugal	5		Serbia	1	1
11	Scotland	1		BeNeLux	3		Rumana	1	1
12	France	1		Greece	1		Greece	0	1
13	Serbia	1		Sweden	1		Sweden	0	1
14	Rumana	1		Scotland	1
15				Rumana	1
16				Serbia	1
Sheet29