How to extract last day total sales data

[eddy9657]

Hello, I am using QlikSense. I want to get the total sales on last day of every month  .January has 31 days. But the day 31 is not in my data.  I want to extract the day 30 as the last. 

I am using 

LOAD...

     If(Month(Datee) = Previous(Month(Datee)), 0, 1) as Flag

Resident ....

Order By Datee DESC;

But is not work because in my data January 30 occur more than one.  Can anyone can provide a way to extract last day total sales data

[andrey_krylov]

Left Join ([TransactionTable]) LOAD Max(Datee) as Datee, 1 as Flag Resident [TransactionTable] Group By Text(Date(Datee, 'YYYYMM'));