Excel pivot table question

[yxz152830]

Gurus,
how do I create a pivot table that looks like below? I was having trouble with creating the 'Roller Coaster' column. And also the way that the Design filter is below the ‘Type' filter in another section. Thank you !

A_Excel Test.xlsx
	B	C	D	E	F	G	H
25	Roller Coaster	Amusement Park	Type	Design	Status	Opened	Speed ( mph )
26	Air	Alton Towers	Steel	Flying	Operating	2002	46.6
27	Boomerang	Pleasure Island Family Theme Park	Steel	Sit Down	Operating	1993	47
28	Cobra	Paultons Park	Steel	Sit Down	Operating	2006	31.1
29	Colossus	Thorpe Park	Steel	Sit Down	Operating	2002	45
30	Corkscrew	Alton Towers	Steel	Sit Down	Operating	1980	40
31	Corkscrew	Flamingo Land Theme Park & Zoo	Steel	Sit Down	Operating	1983	40
32	Crazy Mouse	South Pier	Steel	Sit Down	Operating	1998	29.1
33	Crazy Mouse	Brighton Pier	Steel	Sit Down	Operating	2000	29.1
34	Enigma	Pleasurewood Hills	Steel	Sit Down	Operating	1995	34
35	Express	M&Ds Scotland's Theme Park	Steel	Sit Down	Operating	2006	28
36	Fantasy Mouse	Fantasy Island	Steel	Sit Down	Operating	2000	29.1
1_Pivot

 

[Kerryx]

Switch to classic view

 

[Kerryx]

Putting design in Column field option will give you the layout showing filter you are looking for

 

[Alex Blakenburg]

Slight variation of @Kerryx's showing the Roller Coaster column below:
Also if you haven't opted for the Classic View, then you will want to Design > Report Layout > Show in Tabular View.
You will also want to turn subtotals off by right clicking in the Amusement column and toggling off subtotals.