Pivottable - Header

[harald_popp]

hi,

i am using a pivot table and have a problem with the table header!

please see attached pics! is there an option for solving my problem?

thanks for you help.

regards

-Harald

[sushil353]

Hi,

Try below in your header lable:

Assuming Value is your horizontal dimension name in pivot table.

=Value&'|'&Year

HTH

Sushil

[sorrakis01]

Hi,

Use this in Caption = Value & ' | ' & Year (or '2013','2014').....

Regards

[harald_popp]

hi Sushil,

i tried your solution but i always get both years in the header!

thx for your help.

-Harald

[sorrakis01]

Hi,

I don't understand where is the problem.

Can you upload the exercise?

[harald_popp]

i have added a demo!

thx for your help.

regards

[sorrakis01]

Hi,

Sorry you're right,  it doesn't work when you selected two or more year's values.

I don't find the solution, doesn't work fieldselection, substrtingcount....

Sorry I can't help you

[harald_popp]

thanks for trying!

[#9]

I don't think it is possible here, You need to create flags in script. So, that you can use them in the expression labels