Plotting certain values on chart from an excel file

[#1]

Hi all,

I have got data that looks similar to this:

Continent	Country	City	Population
Asia	China	H.kong	20000
Asia	Japan	Shanghai	125200
Asia	India	Mumbai	7458795
Africa	S.africa	Johannesburg	124578
Africa	Nigeria	abc	1247953
Europe	Italy	Rome	23365487
Europe	Spain	Madrid	9874561
Europe	Portugal	Lisbon	2379451

I am looking to plot a bar graph only for the continent "Europe".

When I select Dimensions in Chart properties and select Continent, then all the continents graph comes up.

Can I get the expression please (Where does this expression need to be added)

How do I select only certian values which is 'Europe' in this case.

Regards,

K.V

[MEllinghausen]

the simple Way, you choose Europe from a Listbox

[#3]

Hi Marcus,

I am looking to create a  bar graph of Europe for which expression needs to be added while selecting dimensions in chart properties. I would like to know the expression and where to add the expression..

.

Regards,

K.V

[MayilVahanan]

HI

Try like this

=Sum({<Continent={'Europe'}>} YourExpression)

Hope it helps

[#5 · Accepted solution]

Hi all,

I found the solution for it.

The expression is:

=

If ( [Continent] = 'Europe', 1, Null() )

- Tick on the check box where it says supress null values

Thanks.

Regards,

K.V