Forum Discussion
Deleted
Jan 31, 2018Top variation elements in a pivot table
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?
- JKPieterseSilver ContributorI guess you must somehow add a field to the source which represents the variation and add that field to the PT.