2 Replies Latest reply on Sep 22, 2016 1:33 AM by Nicholas Sharaf

# Splitting One Column into three by conditions to make a bar chart

I have a table with company names and respective revenues. I want to be able to use this information to create a bar chart showing:

# of companies with revenue > x

# of companies with revenue < y

# of companies with  y<= revenue =<x

This looks like a fairly straightforward exercise but I haven't been able to do it so far. Help please.

• ###### 1. Re: Splitting One Column into three by conditions to make a bar chart

Nicholas,

Use the below formula and and substitute Product Name with Company Name and make other necessary changes. This will break the Companies into three categories.

if {FIXED [Product Name] : SUM([Sales]) } > 1000

THEN 'TOP 20%'

ELSEIF ({FIXED [Product Name] : SUM([Sales]) } < 1000

and {FIXED [Product Name] : SUM([Sales]) } > 100)

THEN 'TOP 60%'

ELSE

'BOTTOM 20%'

END

Good Luck !!

1 of 1 people found this helpful
• ###### 2. Re: Splitting One Column into three by conditions to make a bar chart

Thanks Anoop