firstsortedvalue and AGGR

[rustyfishbones]

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.

[rustyfishbones]

I am using the expression in a Pivot Table

[sasiparupudi1]

Did you try?

Aggr(FirstSortedValue([Entryheader.provide-integral],[Entryheader.item-number]),Entryheader.Zone)

[rustyfishbones]

That does not work, thanks.

[raman_rastogi]

May Like this

FirstSortedValue([Entryheader.provide-integral],-Aggr(Sum([Entryheader.item-number]),[Entryheader.noncust-name],Entryheader.Zone))

[rustyfishbones]

Thanks, but not does not work for me either.

[vishsaggi]

May be try this?

Sum(Aggr(FirstSortedValue([Entryheader.provide-integral],[Entryheader.item-number]), [Entryheader.noncust-name],Entryheader.Zone))