8 Replies Latest reply: Apr 17, 2014 12:52 PM by Anand Chouhan

# Pie Chart

Hi All,

I want to create a pie chart with only certain values (peoples names) in a pie chart.

In my excel column I have a long list of names but only want to show 4 or 5 of these names in my pie chart. Any ideas how to create this?

As you probably know pie charts cant look awful with too much infomartion!

• ###### Re: Pie Chart

Add calculated dimension for that like

=If([peoples names]= 'Name1','Name1',

If([peoples names]= 'Name2','Name2',

If([peoples names]= 'Name3','Name3')))

And click on Suppress When Value Null

• ###### Re: Pie Chart

You can use SET analysis for this also which is better way of doing pie chart calculation

Dimention :- [peoples names]

Expression :- Sum( {<[peoples names] = {'Name1','Name2','Name3','Name4'}>} Values )

• ###### Re: Pie Chart

you can use dimension limit tab in chart properties

• ###### Re: Pie Chart

Create a PIE Chart

USING a Calculated Dimension

Dimension

Use calculated Dimension as below

=IF(Match([People Name],'Name1', 'Name2', 'Name3', 'Name4'),[People Name])

Tick Suppress When Value is NULL

Expression

USING a Set Analysis (Just an Example)

Dimension

[Customer Name]

Expression

SUM({\$<[Customer Name] = {'Name1','Name2','Name3'}>}Sales)

Performance wise, set analysis is better compare to Calculated Dimension

Hope this helps...

• ###### Re: Pie Chart

Use dimension limits

• ###### Re: Pie Chart

@ thanks for this, very much appreciated.

If one of the names is O'Malley for example, how do I work this into my equation as the ' is causing an error?

Thank you to the other people who have also responded.

• ###### Re: Pie Chart

Something like below

SUM({<Name = {"O'Malley","O'Connor"}>}Sales)

• ###### Re: Pie Chart

Ok You can write like this for the

Dimension :-

= If([peoples names]='Name3','Name3',

If([peoples names]='O'&Chr(39)&'Malley','O'&Chr(39)&'Malley',)) // For O'Malley type of string

Or

If you use SET analysis then you can do like

Dimension :- [peoples names]

Expression :- SUM( {< [peoples names] = {"O'Malley"} >} SaleValue )