Excel pivot table query

[Spacedman]

Afternoon all.

I have been tasked with collating all our data into one place, quite a big job really and ive made good progress however i have one small problem;

I want to sort by element which is fine however when i want to sort deeper by type of element the type drop down menu has the types of all elements. I want it to only display the type of the element that has been selected. Is there anyway to do this?

Many thanks!

edit: if no one knows what im talking about please say and ill try to phrase it better, ta

 

[Spacedman]

Bump for pivot table justice!

What i want to do is filter the types of element by the element selected in a different drop down menu.

 

[Spacedman]

Firstly thanks for replying, its a confusing topic.

Basically :

The element is part of a building i.e. external walls and the type is for the different types of external wall i.e. masonry or clad.
Now what i want to happen is if i stick the element menu and the type in the page section, when i select external walls it will automatically filter the items stored in the type column (which i also want to put in the page tab) the only options you can see/select fit the element selected. As it stands it shows everything under the frame from steel frame to sanitary ware.

What you end up with is two drop down menus in the page section with one telling the other what to display in its drop down menu!

Sorry, confusing myself just thinking about it