How to group using last 2 characters and subset the latest data?
Hi all, Is it possible to make a column for groupings using the last two characters from another column? For example, I have this table:FYWGroupingsFY24W381FY24W381FY24W392FY24W392FY24W392FY24W403FY24W414FY24W414 Is it also possible to subset the first 2 latest date according to the grouping? In this example, FY24W40 and FY24W41 will be selected then subset since they are the "latest" data. TIA