Aggregation function

[priyarane]

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.

[giakoum]

how do you determine which CrispName to use?

Citi Bank N or Citi Bank PP

[rubenmarin · Accepted solution]

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.

[priyarane]

Hi Ioannis,

What ever name not a problem. If it is longest name then good.

[priyarane]

RUBEN really Thank You.