I have data showing City and sum of order count.
There are specific categories I'd like these rankings to be produced using (below):
Year-2023; Category-Farming; Order(count)
My output just shows Rank, City, and Order Count. I have Category and Year in the filters pane.
I'd like to get the rankings in a group without having to bring in City so I can just show the overall sum of Orders by the Cities that fall in the criteria above.
Sum of Order Count by Top N Cities: Top 25; 26-50; 51-100
I am unable to find anything on this any help is GREATLY appreciated!!!
Thank you so much, P