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
          Tracy Rodgers

          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