I have a make table query that creates a table that ranks stores in descending order based on sales. In my query properties, I have changed the top values to 50 (I only want to see the top 50 best selling stores). The total number of stores will change weekly. How do I add a column to this query to show the total number of stores available so I can show the following:
Store Sales Rank Total
x $500 1 365
q $435 2 365
a $400 3 365
etc until I have only the top 50 stores. I need to show the Total column so we know that store x is 1 of 365, store q is 2 of 365, etc.
I also run this same query in reverse, sorting in ascending order to get the bottom 50 selling stores and will need the same info.
Thanks in advance for your help!
Store Sales Rank Total
x $500 1 365
q $435 2 365
a $400 3 365
etc until I have only the top 50 stores. I need to show the Total column so we know that store x is 1 of 365, store q is 2 of 365, etc.
I also run this same query in reverse, sorting in ascending order to get the bottom 50 selling stores and will need the same info.
Thanks in advance for your help!