Creating an automated generated max month field in a straight table.
I want to create a straight table that shows total counts by month of the top 30 suppliers and I want them ranked by the total of all months shown. I want the month fields to be automated, so when a new month comes a new field is generated. I have already created the variables for the year start for the max year. I just want to know if I can create that in a straight table.
But when I select a previous year or month it removes some suppliers from the top 30. If that supplier had no counts in that month/year it will drop from the list. If I could somehow lock this expression from allowing field selections to change the ranking.