Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to dynamically label the subtotal lines in a pivot table? So it the below example the total lines should say "Distribution Total" and "Door Systems Total".
Heather,
There is no possible way to change the title of the totalizers PivotTable
The only options are this approach or use the dimensionality function to add the total labels in the expression itself (see attached example).