Display Dimension in Subtotal Label on Pivot Table

inessa_zhurba — Fri, 02 Apr 2021 07:44:33 GMT

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.

topic Display Dimension in Subtotal Label on Pivot Table in App Development