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.
