how to pick max date wise value for each row?

[swarnendu]

Hi all,

I have a table showing Master_Code, Master_Code_NO , dates and quantities:

I want to pick the value   for each master code number using by an expression the last date value in the table

Can someone let me know how ?

i used the expression is

=Sum({<%Tran_Date={'$(vTEST)'}>}Opening_Qty)

where

vTEST =(max({<Opening_Qty = {'<>0'}>}%Tran_Date))

thx.

Swarnendu

[tresesco]

Yes, set analysis section '{<Opening_Qty={'<>0'}>}' is responsible for that. If you want to consider 0 values too, then just remove the set from the expression.

[swarnendu]

Thanks for your helping its working ...

[swarnendu]

need one more help.

if i select month then its show me properly but i want this basis of date range.

i want use  like this {<%Tran_Date={'>=$(vFromDate)<=$(vToDate)'}>}

how i use this ?

[tresesco]

Try like:

FirstSortedValue(Aggr(Sum({<%Tran_Date={'>=$(vFromDate)<=$(vToDate)'}>}Opening_Qty),%Tran_Date,New_MasterCode,MasterCode),-Aggr(Only({<%Tran_Date={'>=$(vFromDate)<=$(vToDate)'}>}%Tran_Date),%Tran_Date,New_MasterCode,MasterCode))

[swarnendu]

Lots of thanks brother...

Its work fine..

[swarnendu]

Brother can you please share your email id.?

[tresesco]

I will, drop a mail in your inbox.