Charts: Sum Issue

[#1]

Hello ,

I'm creating a chart based on the belwo data:

Region      Country         Rev

NAM          US               10

NAM          MEX               5

EMEA        GB                 6

EMEA        GER               9

The issue is that when some body searches the data based on the country the chart is showing the Rev data for that country. For ex: if user searches for Country 'US' the chart shows Rev. number 10,  whereas i alway want the chart to show data at Region Level, i.e it should show 15 for NAM.

How do i achieve this. My chart structure is

Region , Sum(Rev)

----------------------------

Thanks

P

[MayilVahanan]

HI

Try like this

=Sum({<Country=>} Rev)

it exclude the country selection