How to use the aggr function in pivot measure's label
i'm trying to print the result of an aggr function into a measure's label in a pivot table. I had to try the aggr function because apparently, the label doesn't react to the natural aggregation given by the structure of the pivot table. The aggr function always prints out as blank, unless i perform a filter on the column dimension.
Do any of you know how to do this correctly?
I hope i was clear enough, if not i could provide an example qfv, just let me know