Excel 2007 : Choosing The Columns in Pivot Table by Menu

Hi,

(First of all I am sorry if this has been discussed in the forum earlier, I have been trying searching for last half an hour but couldn't manage to find any help.)

Anyways, I have a raw data sheet and I am making a Pivot table from it.

Breif Summary is:

Sales Company (SCO) in Column A
Material in Column B
Then the normal data from column G to H.

Now from M to T

I have the Invnetory (Inv) & Production (Prd) for four plants (BCN, WCZ, FSK & SUK)

Now in Pivot I want to give user a choice to select Inv & Prd for one plant which ever he/she selects.
[The without goinging in the Field Settings of Pivot Table]

Any possibility of doinging that?

I have attached the sheet with the message.

Can you reorganize your raw data so you can add the INV and PRD columns to the report filter, per plant?

Thanks George, that helps!!!

Cheers!

I was with you Roger Govier ..... my bad; I am so sorry ... this is Friday and I am still stuck in Spreadsheets