I have a table called Orders. The Key is order ID.
I have a virtual field call YrMth that holds the year and month for each order Ex. 201912 Year 19 and month 12
I am trying to construct a filtered select statement that allows me to obtain a list of months. i.e [YrMth] where each one is unique. I can then calculate the total sales per month.