Dynamic label for a dimension of pivot table

[miran]

Hi all,

I have a pivot table where the first heading (dimesnion) is the year-month and the second heading (dimesnion) is day of the year and the measure is sales of the product of that day.

The table shows the data correctly. But, What I need now is the label of the second heading (dimesnion) to have the day of week attached, but dimesnion value staying the same . Below is what I am geting.

But what I want is something like this.

I am using expression =billingDate for Feild and  using = billingDate & '-' &  weekday(billingDate ) for the label of the dimension.

But, it doesn't work.  And I cannot make any chnages to expression of the field as it completely changes the table.

Any help is really appreciated.

Thanks