I’m trying to show a bar graph of the Top 10 Clients from a table. Here is my logic and first steps:
- I have a raw database with clients and revenue
- I add a column with a formula for “Accumulates Sales”
- I then filter the table to only show unique clients and their accumulated sales.
- Then I’d like to create a graph to only show top 10 clientes. I tried to use Slice () but it doesn’t work.
I’m stuck and it’s not working… any ideas?
I think it’s not working because: The Slice() formula filters every row in the table and not only the unique client values.
Here’s the doc: Show top 10 clients?