The info is not sufficient.
Could you please attach mocked up sample data as twbx file.
Thank you for responding. Below I have attached a mock up data.
You have shown it only through the indexing or sorting on the basis of a particular value
But my requirement is,
I have to select the Top 5 countries on the basis of volume and show them in a filter so that when I navigate through them,
I'll get the price trend (yearly/monthly/quarterly) as a result.
(NB. Please remember I don't want top 5 values on volume as my output)
mock up data.xlsx 14.0 KB
Please find the below attachment marked as Helpful or Correct to close the thread.
Note:-Please See the Both Sheet i.e.Sheet 1 and Sheet 2 and
Also Refer the Screen shot attached.
Amar D. Savale
Sorry for not replying to your response earlier. I regret that I couldn't provide you a perfect mock up data but those are the fields we got from our client for this requirement. Kindly suggest me the fields which can fit into the requirements.
Coming onto the solution, when I tried for the relevant filter selections, I am not able to get the same things you are getting. I have attached the screenshots here. Kindly guide me through.
Screenshot (212) shows my required view.
(N.B - I am not able to open your workfile. I am using version 10.2)
Thank you for responding but this is certainly not what I am looking for.
Well I tried that one but I am not getting the filters like you.
Then again I went through your sheet and in another sheet I put that into row where I was getting all the names not just only those 5 names.
I am really confused how it's happening like this.
Kindly, review my previous screenshots to know about the process I followed and guide me if I'm doing something wrong.