Merge heading in pivot table

[Anonymous]

Actually I used text object with the following expressions =  Max(Year) &' / ' &  Max(Year-1) and =Max(Year) &' / BUDGET'

I am trying to add heading in pivot table .

I read the following post but I didn't undestand how to use it in my case ?

[sinanozdemir]

Hi,

Maybe something like this:

I used ValueList() in one of the dimensions:

And in the expression, I used Pick(), Match() and ValueList() all together:

I am also attaching the qvw in case you need that as well.

Hope this helps.