Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've got a problem with interrecord-functions. In a Pivot-Table I'd lile to make a refernce from a summary-row to the text of the column left - see snapshot:
So that in the end the text now filled with 'Gesamt' is concatenated with the text of the column 'Auftragsgruppe', e.g.: '9491 Gesamt'. I made several approaches with above, befor, fieldvalue .... but none of them works. Has anybody an idea?
Kind regards,
Matthias
See this post. As far as I know that's the only way to create custom totals labels.
I can't see your screen shot, so it's like a walk in the dark.
I believe you can't reference the other column from your total column using inter record functions. But if you are using a partial sum and the Auftragsgruppe is unambiguous in that context, just call the field value:
=only(Auftragsgruppe) & ' Gesamt'
edit:
Now I can see the screenshot. The solution I suggested won't work.