Hi,
I've a pivot table with hundreds of elements that have a indicator variating over several days. I want to sort, let's say the top 10 elements, for which this indicator present a bigger variation over the time. How can I sort them?
As an example, let's say I have three hundred digital coins and I want to get the 20 coins that presented the biggest variation over the last 20 days.
In theory this seems simple to me but I'm not being able to do it in the pivot. Just can sort the top or bottom elements and not the ones who presented a bigger variation.
Can someone help me?
