Skip to content
Show top 10 clients?
Share
Explore

Show top 10 clients

Step 1
:
Turn “Client” column in Lookup
Option B data
0
Client
Subtotal
1
Héctor
$1,500
2
Ejemplo Héctor
$234
3
Sergio
$2,345
4
Veronica
$665
5
Daniel
$146
6
Hotel A
$1,146
7
Pedro
$3,446
8
Héctor
$2,345
9
Héctor
$776
10
Camila
$327
11
Maria
$754
12
Camila
$75
13
Juan
$745
14
Camila
$868
15
Lucia
$765
16
Ana
$334
17
Ana
$3,457
18
Lucia
$7,453
19
Maria
$45
20
Daniel
$4,000
There are no rows in this table
$31,426
Sum

Step 2
:
Create “Accum. Sales” in new Clients table.

Clients
1
Client
Accum. Sales
1
Lucia
$8,218
2
Héctor
$4,621
3
Daniel
$4,146
4
Ana
$3,791
5
Pedro
$3,446
6
Sergio
$2,345
7
Camila
$1,270
8
Hotel A
$1,146
9
Maria
$799
10
Juan
$745
11
Veronica
$665
12
Ejemplo Héctor
$234
There are no rows in this table
Step 3:
Create Graph

Use Filter: thisRow.In(thisTable.Sort(false(),thisTable.[Accum. Sales]).Slice(1,10))
Top 10 Clients
1
Created with Highcharts 9.2.1ClientAccum. SalesLuciaHéctorDanielAnaPedroSergioCamilaHotel AMariaJuan01k2k3k4k5k6k7k8k9k





Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.