Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Inter-Record-Function

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

2 Replies
Gysbert_Wassenaar

See this post. As far as I know that's the only way to create custom totals labels.


talk is cheap, supply exceeds demand
swuehl
MVP
MVP

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.