Display Dimension in Subtotal Label on Pivot Table

[inessa_zhurba]

Hello,

I am trying to include dimension into "Total" expression. Pic is attached.

Instead of Yearly Total I wanted to say: 'Total for: ' & BillingYear

which is a dimension on a pivot table.

When I Included & BillingYear to Totals Label Expression - it only displays  'Total for: ' and nothing else.

How to make it display the year as well.

I wanted to have Totals Label say:

Total for: 2016

Total for: 2017

etc...

I was try to include it as a text: 'Total for: ' & text(BillingYear)  ---still doesn't work!

What am I missing here?

Any help is appreciated!

Thanks,

Inessa.