Pivot Table Help

suraiya

New Member
Joined
Nov 18, 2014
Messages
3
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.



Year8
Event TypeGNR
Year
891011121314
FEB145 8
BNR8 1 55 7
BUK225 8 8
COF 8 8 557
DCUK 2
DUM822 88
FBT 74558
GNR45 8 18
<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
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
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

Well-known Member
Joined
Oct 24, 2015
Messages
6,684
something like this?

Event
8
9
10
11
12
13
14
Year8
FEB
1​
45​
8​
EventGNR
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

Well-known Member
Joined
Oct 24, 2015
Messages
6,684
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 812
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​
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,614
Messages
5,523,902
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top