Q???

[rabbani_sk]

Hi All,

My actual data values in a strgt Table is as follows,

ItemNo    [Production  Date]     [Ordered Qty]       [Prod. Qty]

S007          10/09/2011                 28                          2

S007          17/08/2011                 28                       -12

S007          17/08/2011                 28                         -1

S007          17/08/2011                 28                         -2

S007          17/08/2011                 28                         -1

My requirement is , Need to filter the [Production Date] with 'Maximum date' and at the same time need to sum the [Prod. Qty] , my final Solution should  be as follows

ItemNo    [Production  Date]     [Ordered Qty]       [Prod. Qty]

S007          10/09/2011                 28                          -16

[swuehl]

Maybe try using ItemNo as dimension and

=Date(max([Production Date]))

=only([Ordered Qty])

=sum([Prod. Qty])

as expressions