1 Reply Latest reply: Dec 21, 2012 2:33 PM by Mayil Vahanan Ramasamy RSS

    Charts: Sum Issue

      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