6 Replies Latest reply on Feb 4, 2019 2:34 PM by Shyam Sundar Ranganathan

Top 10 results based on Filter condition

Shyam Sundar Ranganathan Jan 29, 2019 3:05 PM

Hello Everyone,

I have sales information of stores and want to list the top 10 products based on sales for a selected store through filter condition. I used Index, but then it ranks across all stores. Used Context filter to the store and tried to list the top 10 ,still not able to achieve the exoected result. I would like to have your suggestions on this problem.

Thanks!

1. Re: Top 10 results based on Filter condition

Joe Oppelt Jan 29, 2019 3:10 PM (in response to Shyam Sundar Ranganathan)

Are you using a table calc (like INDEX) to filter your sheet?

If so, that will leave all the data in the underlying table and the ranking will be done for all rows.

I have more questions than answers right now, and I really need to see your packaged workbook if I'm going to be effective helping you here.
Like Show 0 Likes(0)

Actions
2. Re: Top 10 results based on Filter condition

Joe Oppelt Jan 29, 2019 3:11 PM (in response to Joe Oppelt)

If you can't share your data, you can anonymize your data and workbook as demonstrated in the video linked here:

Video demonstrates how to anonymize your workbook/data
Like Show 0 Likes(0)

Actions
3. Re: Top 10 results based on Filter condition

Shyam Sundar Ranganathan Jan 29, 2019 3:18 PM (in response to Joe Oppelt)

Hello Joe,

Yes , as you said I used Index and it applied across stores.

What I want is to chose a store from the filter and for that store, I want top 10 products based on sales. I would be happy to share but due to sensitive data , I can't share the workbook. Is it possible to suggest without the workbook?
Like Show 0 Likes(0)

Actions
4. Re: Top 10 results based on Filter condition

Joe Oppelt Jan 29, 2019 3:57 PM (in response to Shyam Sundar Ranganathan)

Hack up an equivalent scenario using Superstore. Use Customer instead of Store, and Products will line up like your products.

It's the principle and structure that's important. Not your specific data. We can work with that, and then you can replicate what we figure out in Superstore into your own workbook.
Like Show 0 Likes(0)

Actions
5. Re: Top 10 results based on Filter condition

Shyam Sundar Ranganathan Feb 4, 2019 11:05 AM (in response to Shyam Sundar Ranganathan)

Hello Joe,

Thanks for your inputs, I have found the solution for the issue and as you suggested, going forward, ill post a sample workbook for better understanding and faster results.

Thanks,
Shyam
Like Show 0 Likes(0)

Actions
6. Re: Top 10 results based on Filter condition

Shyam Sundar Ranganathan Feb 4, 2019 2:34 PM (in response to Joe Oppelt)

Hello Joe,

I have posted a question '"Fixed Column Referencing" with the workbook. I would like to have your opinion on it.

Thanks,
Shyam
Like Show 0 Likes(0)

Actions