Aggr Function Issue

[azmeerrehan]

I have a straight table  and I am using this expression

SUm(Aggr(

If(sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty)>

sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'}>} sum_orders),

sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'}>} sum_orders),

sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty)),Prod_Variety_Number))

My Dimension is Prod_Variety_Number, but I am loosing rows when I am doing this expression.

Any idea what am I doing wrong?

[azmeerrehan]

The second chart at the bottom expect to see 1330391

[Anil_Babu_Samineni]

Not sure about your application, May be share to investigate. But sample data looks working?

[azmeerrehan]

what is ur expression for this sample out put

[azmeerrehan]

Can u pls share ur  qvw

[Anil_Babu_Samineni]

PFA

[Anil_Babu_Samineni]

IS that helps? If not, Please post sample application to investigate?