FirstSortedValue doesnt work

[#1]

Dear All,

I have attached my two QV documents in which i used firstsortedvalue function.

As per my understanding i passed parameters, but its not working.

My aim to show CID and only the first ACNT from each CID group and sum of that particular ACNT.

Thanks & Regards,

Aqeel Nawaz

[tresesco]

Try like: = MinString(ACNT)

PFA

[#3]

Thanks Tresesco.

But what to do with the sum of Amount for only that particular ACNT.

[manojkulkarni]

use

sum(aggr((AMT),ACNT))

[tresesco]

Use calculated dimension like: =Aggr( MinString(ACNT), CID)

PFA