Hi All

I have following source data

Country........... Polulation
UK----------------100
USA---------------200
INDIA--------------300

Now can I create a pivot view which will give me Only UK population and
Other population? I don't want to display all other countries, it should just
sum up other contries and give me result as others.

Output in view

Country-------Population
UK-------------100
Other----------500

I tried Calculated fields?? but no luck...

Thanks in advance...