Pivot Table Help

[suraiya]

Hello

I am trying to create a PT that would show some event registration summary. My data consists of different event types users have registered for over various years, what I would like to be able to filter a specific year and event type and pivot what other events the users have registered for. Please help, I feel like I am missing something obvious! Below is what I am trying to achieve.

Year	8
Event Type	GNR
	Year
	8	9	10	11	12	13	14
FEB	1	45				8
BNR	8		1		55		7
BUK	2	25			8		8
COF		8		8		55	7
DCUK				2
DUM	8	2	2			8	8
FBT		7	4	55	8
GNR	45		8			1	8

<colgroup><col width="84" style="width: 63pt; mso-width-source: userset; mso-width-alt: 3072;"> <col width="79" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;" span="7"> <tbody> </tbody>

Hope that makes sense

Suraiya

 

[Fazza]

hello

it doesn't make sense to me

when filtering for a specific year & event type, how can the results have data from other years and events?

some further explanation would help

thanks

 

[sandy666]

something like this?

Event	8​	9​	10​	11​	12​	13​	14​		Year	8
FEB	1​	45​				8​			Event	GNR
BNR	8​		1​		55​		7​
BUK	2​	25​			8​		8​		Value	Year
COF		8​		8​		55​	7​		Event	8
DCUK				2​					GNR	45​
DUM	8​	2​	2​			8​	8​
FBT		7​	4​	55​	8​
GNR	45​		8​			1​	8​

 

[sandy666]

or like this?

Event	8​	9​	10​	11​	12​	13​	14​		Year	(Multiple Items)
FEB	1​	45​				8​			Event	(Multiple Items)
BNR	8​		1​		55​		7​
BUK	2​	25​			8​		8​		Value	Year
COF		8​		8​		55​	7​		Event	8	12
DCUK				2​					BNR	8​	55​
DUM	8​	2​	2​			8​	8​		DUM	8​
FBT		7​	4​	55​	8​				GNR	45​
GNR	45​		8​			1​	8​