Pivot table Show only one option

[Dinesh121]

Hi,


I have a set of data which has a column with years eg:2001,2002..20110.


I would like to show only 2010 in the report filter. Is there any way to do this?


-Dinesh

 

[Hui]

Dinesh


Select the table including headers


Goto Data, Filter

Now select the field Header, there should be a small drop down arrow on the right of the field header

Select that and select what ever values you require eg: 2010, uncheck all the others

 

[Dinesh121]

Hey Hui,


Thanks for the Quick reply.. I want the filter to show only one value eventhough it has a lot of options. eg 2010.Rest I don't want users to change or give them an option to change in the field header.Is it possible?


-Thanks

Dinesh

 

[Hui]

Dinesh

You can set a password on the sheet and disable/lock various aspects of the sheet

 

[Dinesh121]

ok Hui.. I will give a try .. Thanks a lot for your help and Quick reply.