Last transactional date in last month.....

    Hello there,

    Is there a way to reference the value in the last row highlighted in yellow another object preferably a text box.

    The requirement is to display the last deposit amount in the last month of the current year  but this sample report in the pivot table displays all the deposit in the last month.

    I have tried to use the FirstSortedValue(deposit,-Date) but was not desirable.

     

    Essentially my challenge is to get the  Max date from the last Month variable ;

    vLastMonth =Month(date(AddMonths(max(Date), -1))) 

     

    Monthend function also gives me the traditional days but not the exact transactional date the deposit was made.


    Please help!.

     

     

    Capture.PNG