Label in Pivot Table

[Anonymous]

Hi all,

I want to build a pivot table like this

The label for each expression is the Year and the Dimension Value (Red circle)

However, it doesn't work as what I expected, it only shows the Year, it cannot get the Dimension value

Is there any function I can get the Value of the Dimension and put it in the label?

Attached the QVW for reference.

Many Thanks!!!!

Paddy

[jagan]

Hi,

Can you attach some sample file?  You want to replace Header 3 or Header4 with Department A- Team1 and Department B- Team2?

Regards,

Jagan.

[sujeetsingh]

Come in more words and better with sample .

[HirisH_V7]

Hi paddy ,

Jus remove the dimension team . You will have single Header "Team and Department" is this you require or can you explain more .

Regards,

hirish