Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Below is my requirement. Could some one please help me? since yesterday I am trying for it.
Expression - sum(EAD)
Ex
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.
Hi Priya, you can change the first dimension to:
=Aggr(Minstring(CrispName), CSAID, Parent)
If you don't want the first alphabetical name, change MinString(CrispName) for the expression you need to select the correct name.
how do you determine which CrispName to use?
Citi Bank N or Citi Bank PP
Hi Priya, you can change the first dimension to:
=Aggr(Minstring(CrispName), CSAID, Parent)
If you don't want the first alphabetical name, change MinString(CrispName) for the expression you need to select the correct name.
Hi Ioannis,
What ever name not a problem. If it is longest name then good.
RUBEN really Thank You.