Label

[NavinReddy]

Dear All,

In pivot table when drill down Label should be changing as per drill down ,

if any sample document please share with me

Thanks In Advance

Niranjan

[MK_QSL]

Dear Niru,

Dont understand your question properly.

Can you please be more specific?

Thanks

[NavinReddy]

Hi Manish,

we have drill down like (HR-->Manager-->TL-->Senior Analyst-->Developer)

in drill down pivot table like this format

when Click drill in  HR label should display HR 

when Click drill in Manager label should display Manager

when Click drill in TL label should display TL

like same as it is

please help me do this

Best Regards,

Niranjan

[MK_QSL · Accepted solution]

Create a Text Box with below in expression

=GetCurrentField([Your Group Name])

[NavinReddy]

Thank you so much Manish

Regards,

Niru

[MK_QSL]

Only HelpFul Answer ?

Doesn't this solved your problem?

[NavinReddy]

Ha ha ..Thank you so much.........