Sales range as chart dimension

[Anonymous]

Hi,

Does any know how to script Sales Range as a dimension of a chart to show number of salesperson in each of such range?   Thanks.

Salesperson	Sales Record in Mar
A	20
A	80
A	40
B	55
B	75
C	50

Expected Result

Total Sales < 100     :    1 sales person (C)

Total Sales > 100     :    2 sales person (A & B)

[sunny_talwar · Accepted solution]

May be with a calculated dimension like this

=Aggr(If(Sum([Sales Record in Mar]) < 100, 'Total Sales < 100', 'Total Sales >= 100'), Salesperson)