Dynamic label for a dimension of pivot table

miran — Tue, 05 Dec 2023 17:07:43 GMT

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

topic Dynamic label for a dimension of pivot table in App Development

Dynamic label for a dimension of pivot table