Hi,
Workbook with attempts attached.
I've been trying to sum the last 3 values based on dates for each customer, , but rather than grouping I'd like to use Table.SelectRows;
I've got
This returns a column of tables of each customer, withing this I'd like to restrict this to only the last / max 3 dates.Please Login or Register to view this content.
I've got as far as
but the last clause is seeing all the dates, I did think of usingPlease Login or Register to view this content.
or A Source [Date] ,Please Login or Register to view this content.
but no good,
Any Suggestions,
Richard
Bookmarks