Pie Chart Display

[shannoypaul]

Hi,

ConsumerType is a field with 4 values High, Medium, Low and Very Low.

I have to consider only 3 i.e High, Medium, Low and display their respective percentages.

Please help me out.

Thanks in advance!

[simenkg]

If you have ConsumerType as Dimension

and have the expression as

sum(Value) / sum( Total Value)

or
count(ConsumerID) / count(Total ConsumerID)

Now you can pick the ConsumerType from a Listbox and the chart will show the percentages between the selected ConsumerTypes

[kaushiknsolanki]

HI,

     You can write an calculated dimension as below.

     =if(ConsumerType = 'Very Low',null(),ConsumerType )

     Select "Supress When Value is Null"

     Go to Expression and write your expression and click on "Relative"

     Also click on "values on Data Point".

     Go to "Numbers" tab and click on the expression and select "Show in %"

Regards,

Kaushik Solanki

[m_woolf]

Try a calculated dimension something like:

if(ConsumerType<>'Very Low',ConsumerType)

[simenkg · Accepted solution]

I'll add that if you somehow want to lock the choices you do it by using Set analysis.

if you dont want to show Very Low, the expressions become

Count({$<ConsumerType-={'Very Low'}>} ConsumerID) / Count(total {$<ConsumerType-={'Very Low'}>} ConsumerID)

or if you like this syntax better:
Count({$<ConsumerType={'High','Medium','Low'}>} ConsumerID) / Count(total {$<ConsumerType={'High','Medium','Low'}>} ConsumerID)