Total doesnt work but aggr does

Mon, 10 Dec 2012 06:20:46 GMT

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

Re: Total doesnt work but aggr does

Mon, 10 Dec 2012 07:03:39 GMT

Hi,

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

Hope it helps you!!

Regards,

chandra