Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I have list of around 50 employee headed by 5 person .
My requirement is to track sales ID by some 10 employee for any given date range .
But my set expression reduces the list of employee than needed .
I tried expression with pivot , but in vain
1) Count( DISTINCT {<TRANS={'B'},TYPE={'Music'},DATEE={">=$(=Date(eStartDate))<=$(=Date(eEndDate))"} >}ACTION_ID)
2) Count( DISTINCT {<NAME= {'Karole Peskett','Nikolaos Meedendorpe','Reg Andrzejak','Sigismondo Rudram','Antonius Beatens','Axel Este','Barny Chown'}, TRANS={'B'},TYPE={'Music'},DATEE={">=$(=Date(eStartDate))<=$(=Date(eEndDate))"} >}ACTION_ID)
With both above expression , i could not get desired , below result
Basically i need a set expression should give me the count of distinct ACTION_ID for given set of names against above Heads .
Thanks & Regards
Shekar
Thank You Sunny Bhai , it helped ....