Total doesnt work but aggr does

[#1]

LOAD * Inline [test,Make,    FV_Date,    Sub_Version,    Dev_Count

1,BP,    2012    ,4,    87933

1,BP,    2013    ,4,    91262

1,BP,    2012    ,1,    91837

1,BP,    2014    ,5,    86943

1,Con,2012,3,23

1,Con,2013,4,56

I need the following result

BP 86943

Con 56

I used dimension as Make and expression

1)----sum(if(Sub_Version=aggr(NODISTINCT max(Sub_Version),Make) and FV_Date=aggr(NODISTINCT max(FV_Date),Make),Dev_Count,0))

I got the result

But when i use the below expression

2)----sum(if(Sub_Version=max(total<Make> Sub_Version) and FV_Date=max(total<Make> FV_Date ),(Dev_Count),0))

I get -

Can someone explain me why total<> doesnt work as ideally both expression should have worked

[#2]

Hi,

plz find the attachment for your solution.. i did some experiments in attached file.

Hope it helps you!!

Regards,

chandra