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.

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
<ChristopherNav...@discussions.microsoft.com> 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.

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
> <ChristopherNav...@discussions.microsoft.com> 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.
>
>

I don't use pivot tables, so I can't really advise you any further.
However, if you re-post with a title like "Drill down in Pivot Tables"
rather than "Critical requirement", the post might catch the eyes of
someone more knowledgable than I. Also, posting in the .programming
group might be a more appropriate location.

Pete

On Jun 22, 12:10*pm, Christopher Naveen
<ChristopherNav...@discussions.microsoft.com> wrote:
> 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 briefu
> with some screen shots. Thank u very much for ur response.
>
> Eagerly waiting for ur reply.
>
> chr