Create summed expression of most recent month (selected or not)
I am trying to create a text summary that summarizes quantity from three dimensions. So total where A=x; B=x; and C=x. My issue is that one of the dimensions is Month. I tired num(sum(if(match([month_field],max(month_field),qty_field,0)),'#,##0') and this results in errors. I'v tried creating a variable of most recent month and matching month_field to that but both result in 0.
I'd like to have this static so that selections of months don't impact the text summary, but i'd settle just to formulate the expression so it works. 😉