Most of us (I assume) don't speak Spanish (no habla espanol). You may want to translate before posting, if possible.
I understand your meaning, and will take a look.
Can you help me to filter only the best sellers by City?
How do you want them filtered? Any specific number of best sellers? Or do you mean Sort/Rank them from highest to lowest?
Hello, Can you help me to filter only the best sellers by City?
Yes... I only meant for future posts.
Back to the question at hand--how do you want them ordered?
You are right. I was just curious to know what is the question.
On Wed, Oct 16, 2013 at 7:31 PM, Matthew Lutton <
I ranked your sales by City, but for some reason, couldn't get the sort order to work out (even though I set the sort as Sum(Sales) in descending order in the advanced table calc dialog--someone will know why this didn't work out but I'm clueless right now). I placed a filter to select the top however many you want. There are many other ways to do something like this, and I obviously didn't get it fully worked out and am out of time for forum work right now.
I created an INDEX() calc (named rank--version 8.1 will have built in ranking functions), with an advanced compute using setting, restarting every city.
Cheers, and best of luck.
I was elaborating in the same direction you did. Your were faster than me. Your solution get the answer to the Diegos' question.
I stalk the forum looking for questions I can actually answer! This is how I've learned 90% of what I know.
It does work, in terms of properly ranking. However, the sort order is not correct.
Jonathan Drummey: I realize there was a sort on city, but even clearing that doesn't allow me to sort the rankings/sales from high to low properly. What have I done wrong?
Yes--what impact does the copy of Rank have? Please explain
Well, and retain only the 1 of each city create a set.
It's actually same as original rank. First I tried to just duplicate original rank and move it before Product Name, because Product name affects to sorting. But removing "Show header" hides both rank values. If you don't need Rank values you can just move Rank before Product Name.
1 of 1 people found this helpful
Just filter to #1 for each, then.
You could probably accomplish this using a set or two, as well, but I'm not as familiar with that approach with multiple dimensions.
I still don't understand what the duplicate rank does or how it helps. Oh well
Ok, thank you very much and sorry for my bad English writing.