I would like to solve this.
i) give the flexibility to filter by index_1 to index_2
ii) Find the max day of day percentage difference
iii) and find the country where max day of day percentage difference happened.
iv) list the value.
Update : I have done the first part. can filter by the index and sort the percent difference now.
Now question is how to sort by max percent of difference? When i change index_1 to index_2 in parameter control, I need manually sort the percent of difference because the country column wonot be changed.
Message was edited by: cute QQ
Can you attach your packaged workbook (twbx)?