Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the following 2 expression
exp1 Aggr(Sum([Entryheader.provide-integral]), [Entryheader.noncust-name],Entryheader.Zone)
exp 2 FirstSortedValue([Entryheader.provide-integral],[Entryheader.item-number])
both work as stand alone expression for testing but I need to combine the 2 and I am having issues
Any help is appreciated.
I am using the expression in a Pivot Table
Did you try?
Aggr(FirstSortedValue([Entryheader.provide-integral],[Entryheader.item-number]),Entryheader.Zone)
That does not work, thanks.
May Like this
FirstSortedValue([Entryheader.provide-integral],-Aggr(Sum([Entryheader.item-number]),[Entryheader.noncust-name],Entryheader.Zone))
Thanks, but not does not work for me either.
May be try this?
Sum(Aggr(FirstSortedValue([Entryheader.provide-integral],[Entryheader.item-number]), [Entryheader.noncust-name],Entryheader.Zone))