Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like: = MinString(ACNT)
PFA
Thanks Tresesco.
But what to do with the sum of Amount for only that particular ACNT.
use
sum(aggr((AMT),ACNT))
Use calculated dimension like: =Aggr( MinString(ACNT), CID)
PFA