Manipulating filed value in pivot table

[#1]

I need some help in manipulating values at chart level. Below is the scenario.

I have two columns a pivot table in the below format

Country   Sum(sales)

IN             1000

India         2000

US            3000

USA          4000

Ideally both IN,INDIA  mean same and the same with US,USA

Now i need the data in below format.

Country  Sum(Sales)

IN           3000

US         7000

Any suggestions would be greatly helpful !

[#2]

Hi Sushil,

              the column i gave is a sample one. In my case i have only few values in the column and the scenario you mentioned may not occur in my requirement. Thanks for pointing though. . will be cautious when using elsewhere 😉