Sales range as calculated dimension

[Anonymous]

Hi,

Does anyone know how to make a bar chart that count the number of salesperson by sales-range as calculated dimension?  Thanks.

Salesperson	Sales in Mar
A	300
A	1500
B	900
B	300
C	200
C	300

Expected result

Sales < 1000 :  1 salesperson (C)

Sales > 1000 and < 2000 :  2 salesperson (A & B)

[sunny_talwar]

Check my response here:

Sales range as chart dimension

[OmarBenSalem]

try to alter your script like this:

the in your bar chart, as dimension 'sales amount' and measure: count(salesman)

table:

load

SalesMan,

Sales

from ....

leftj join(table)

LOAD

SalesMan,

sum(Sales) as SommeSales

Resident table

Group By SalesMan;

SalesTable:

LOAD SalesMan,

Sales,

if(SommeSales<=1000,'<1000','>1000') as "Sales Amount",

Resident table;

DROP Table table;

result:

[Anonymous]

Thank you.

After applied modifier to the script, it turned out invalid dimension.  Following is the script:

=Aggr(if(Sum({<[PRODUCTION.CATE_CODE]={'01'}, [PRODUCTION.MONTH_PERIOD]={'13'}>}[PRODUCTION.SALES]    ) < 10000,  'Sales < 10000',  'Sales >= 10000'),[SalePerson])

[sunny_talwar]

I don't see anything wrong here, would you be able to share a sample where you tried this and it did not work?

[Anonymous]

Corrected the script, now it works.  Thanks.

For salesperson without any sales record, it returns a ' - ' group.  How can it combine with the 0-sales group?

Sales        No. of Sales person

0               10

<100          22

-                 15

[sunny_talwar]

It should fall into <100, is it not? Difficult to say without taking a look

[OmarBenSalem]

Can you leave us a picture of the problem? Thanks

[Anonymous · Accepted solution]

Found work around to the issue.   Thanks Sunny and Omar.

[sunny_talwar]

What was the work around? Can you share that information with us?