Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I got a difficult issue like below. Please help me on it.
Summary reporting where we need to identify any records having same Parent ID and with the same CSA ID, in this case we pick the longest CRISP Parent Full Name and only display one record with their aggregate P0 - P15
Example as I attached.
Thank you.
Ruben has answered for this, you can check it on below link
Hi Priya,
Try like this:
Aggr(count(feildname),dimension)
in your case
Aggr(count(filedname),Parent ID,CAS ID)
Please provide the same data and app that will be more helpful to frame an expression
Ruben has answered for this, you can check it on below link