I need to rank sales performance of a set of items within different groups

[Brandon12]

Hello,

I am newer to Access and running into an issue with ranking. I have three columns of data and I am wanting to rank each row based on Column C, but contained within the group that is assigned in Column A. In short, Column B has a lot of duplicates, and I need to see how each unique items ranks within the group. Here is an example:

Group	Item	Sales	Rank
Group A	Item X	$9	2
Group A	Item Y	$10	1
Group A	Item Z	$5	3
Group B	Item X	$22	1
Group B	Item Y	$13	2
Group C	Item X	$7	1

Thank you in advance for any help!

[CJ_London]

see post #6 of this thread. Almost exactly the same question

https://www.accessforums.net/showthr...078#post408078

[Brandon12]

Thank you, Ajax! Should I close this thread then?

[CJ_London]

only if you get the solution to work. Otherwise come back with what you actually have. Under Thread tools, you should see an option to mark as solved