Hi Pete,

Thanks for your immediate response.

I tried searching for drill down option in the discusion gropus but no
solutions are helping my requirement. i read all the queries in ithe
discussion grups but everything is different.

Shud i need to create a macro for this requirement?

May i request you to help me with some other examples so that i can try it
again. I hope u understood my requirement, if not pls. tell me will brief u
with some screen shots. Thank u very much for ur response.

Eagerly waiting for ur reply.

chr


"Pete_UK" wrote:

What you describe is often referred to as Drill-down - do a Google
search for drill down in the Excel groups and you will get hundreds of
hits.

Hope this helps.

Pete

On Jun 21, 2:18 pm, Christopher Naveen
wrote:
Hi,

I have the data in 1 col as mentioned below,

Col A
America
America
America
India
India
India
Japan
Japan
Japan
Country
Country
Country
Country
Country

I am creating a pivot table based on this data and now if i select America
in COl A Field it shud pickup (means if i double click on the total it shud
display the extract) america + Country (Ex : America 1st 3 lines and Country
last 5 Lines, Same wayy if i select India it shud pick up 4th - 6th line and
last 5 Lines for country). So Last 5 Lines are constant and the country name
shud vary.

I Hope u understood my requirement. I alreadey spent enough time on this
requirement but not successful.

I would request any one of u to help to get my output. Thanks in Advance!

Chr.