Pivot Table Label Expresion

[dhborchardt]

I would like to show the Sum  of vacation days for each department and keep it static like in the example below. I am guessing I need to do a expression in the label. Something like:  =Department & " = " & Sum(xxxxxxxx).    x = the sum of all the employees in the department featured. Maybe there is a more elegant way to do this?

Pivot Table
Department	Name	Vacation Days
Finance = 22	Bob	11
	Sue	4
	Phil	7
Sales = 16	Joe	5
	Kim	2
	Bill	9
Shipping = 14	Jane	8
	Doug	1
	Jill	5

[Gysbert_Wassenaar · Accepted solution]

You'll need a calculated dimension: =[Department] & ' = ' &  aggr(sum(xxxxx),Department). It's not very elegant, but it's the only way. You can't create dynamic labels for (sub)totals for individual dimension values.