1 Reply Latest reply on Aug 6, 2012 1:45 PM by Tracy Rodgers

# Less than, Greater than, In Between Chart

Good Afternoon,

I'm trying to dissect a certain division's performance and am trying to create a chart and/or table that analyzes its individual sales.

My dimensions are: Division, Product Group, Product #, and Sales Rep.

My measures are: Total and # of Records

Ultimately what I would like to do is have a chart that divides a division's sales into groups:

Less than \$0 in Revenue

Between \$0 and \$499

Between \$500 and \$999

Between \$1000 and \$4999

Between \$5000 and \$10,000

Between \$10,000 and \$49,999

Between \$50,000 and \$99,999

Between \$100,000 and \$499,999

Between \$500,000 and \$999,999

Between \$1M and \$1.499M

And then have a chart that shows me how many sales were made by product group or sales rep.

Please help

• ###### 1. Re: Less than, Greater than, In Between Chart

Hi Tony,

By creating a calculated field similar to the following should allow you to group your dimensions:

if sum(Sales)<0 then 'Less than \$0 in Revenue'

elseif sum(Sales)<500 then 'Between \$0 and \$499'

elseif sum(Sales)<1000 then 'Between \$500 and \$999'

elseif sum(Sales)<5000 then 'Between \$1000 and \$4999'

elseif sum(Sales)<10000 then 'Between \$5,000 and \$9999'

elseif sum(Sales)>=10000 then 'Greater than \$10,000'

end

Hope this helps!

-Tracy