Data Source Manipulation

Hello guys!

So, I'll try to demonstrate in the simpliest way, what I want:

I have this data source (example data):

and I want that (top 5 sources based on highest values and the last source as the sum of all others):

Thank you

1 comment

  • 0
    Meggan King

    Hi Arthur,

    Normally you could just use a filter and select 'Top 5', however this will exclude the other option. To do that, you'd need to create a formula to sort the values, slice the top 5 and then SUM the rest, probably in an ARRAY. Have you explored our functions yet? 



Please sign in to leave a comment.