Hi Milind,

What I usually do in those cases, I add an additional column to my data
source. You might want use the if formula so that everytime you have UK it
will leave UK but if it's something else then have the formula return other.
Hope that helps.

"Milind Keer" wrote:

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...