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.
Total Sales < 100 : 1 sales person (C)
Total Sales > 100 : 2 sales person (A & B)
May be with a calculated dimension like this
=Aggr(If(Sum([Sales Record in Mar]) < 100, 'Total Sales < 100', 'Total Sales >= 100'), Salesperson)
Retrieving data ...