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
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
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?
Thanks