Aggr Help

[thomas_skariah]

Hi all,

Can anyone suggest to solve the following scenario.Attached is the excel file.

I want the following filteration B_Name='Customer',Type='Act',Max of RptPeriod for each KPI code,Min of Level for each KPI code and max(flag_curr) for each KPI code.....with sum of value for each KPI_code.

Find the actual output in excel file attached.

Regards,

Tom

[thomas_skariah]

Anyone any help?

[kaushiknsolanki]

Hi,

     Have a look at the attached exmaple.

Regards,

Kaushik Solanki

[Sokkorn]

Hi Tom m,

Let try this load script

[Data]:
LOAD 
    Selection, 
    Year, 
    KPI_CODE, 
    B_NAME, 
    Type, 
    RptPeriod, 
    Level, 
    Flag, 
    Flag_Curr, 
    Value
FROM
(biff, embedded labels, table is [Input$]) Where B_NAME = 'Customer' and Type = 'ACT';
[MaxRptPeriod]:
Inner Join ([Data])
LOAD
    KPI_CODE,
    Max(RptPeriod)    AS [RptPeriod]
Resident [Data] Group BY KPI_CODE;
[MinLevel]:
Inner Join ([Data])
LOAD
    KPI_CODE,
    Min(Level)    AS [Level]
Resident [Data] Group BY KPI_CODE;
[MaxFlag_Curr]:
Inner Join ([Data])
LOAD
    KPI_CODE,
    Max(Flag_Curr)    AS [Flag_Curr]
Resident [Data] Group BY KPI_CODE;

See the sample attached file.

Regards,

Sokkorn

[#5 · Accepted solution]

See attached example. By adding the flag you can view the original data if you wish.