Aggregate values

Hi All,

I have a table with date (“Dt”) on column and two dimensions (“Code” “Name”)  in rows.

I have a calculated filed (“Transition”) which I am displaying as text.

What I want is a aggregate of all the records for Dimension “Name”

So the result that I am among at is -

Code  Name   

    A.     pad         5

             pad2      1

However, whenever I am using aggregation I am not getting the desired value. I tried using LOD's too. 

Any suggestion would be helpful. I have attached the workbook - Aggregate values.

Regards,

Rishi