How to find a max date of each months balance value ???

[#1]

How to find a max date of each months balance value ???

I used the below expression through this i can get only the max of selected month date balance only

for example

      if i select apr, may, Jun, Jul then it shows the jul 31st closing balance of all apr may jun and jul months but i

expect  

    Apr      6257.11

    May    6257.11

    Jun     6257.11

     Jul      6257.11

But expected result is

    Apr     5259.15

    May    7256.38

    Jun     5930.41

    Jul      6257.11

the expression i used is

=sum({<Num_Trx_Date={'<=$(=num(vDashboardMaxDate))'},AMISDETAILID={'10022000012879'},YearEnd_Flag={'Without Year End'}>}BS_Amount*Flag)/$(vDiv)

[#2]

Hi,

Just Aggregate it by month..So that it will take the Max date for each month and will sove your problem.

Sum(Aggr(

sum({<Num_Trx_Date={'<=$(=num(vDashboardMaxDate))'},AMISDETAILID={'10022000012879'},YearEnd_Flag={'Without Year End'}>}BS_Amount*Flag)/$(vDiv)

,Month

))

Regards,

Desmortes