Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
below is my requirement and example as atacehed(Ex)
display first Crisp name to avoid duplicates for unique combination (PARENT + CSA)"
And I have attached Ead dashboard which is current one.
Thanks you,
Priya
Ruben has answered for this, you can check it on below link
Hi Priya,
your aggr expression should be something like this
aggr(sum(P1),CSA ID,PARENT ID) and in the chart you should not include dimension as CRISP Parent full name.
if you still want it to happen even after adding CRISP name then you need to look in purgechar keep char functions and get the names same.
Hi Deepak,,
Could you please elaborate, if you don't mind
Expression - sum(EAD)
Ex
here its not the case. We need to group the data by CSAID and PARENT(Dimensions)
Total Dimensions in my pivot table/data like below
CrispName Parent CSAID Period: P0 P1 P2 P3
Citi Bank N Citi 0 100 10 20 3
Citi Bank PP Citi 0 2 3 5 8
Citi Bank TT Citi 5 1 10 55 88
Result like:
CrispName Parent CSAID Period: P0 P1 P2 P3
Citi Bank N Citi 0 102 13 25 11
Citi Bank TT Citi 5 1 10 55 88
Here Parent and CSAID should be unique.
Ruben has answered for this, you can check it on below link