How do i display all?

[n1ef5ng1]

Hi,

Example, I have a field name call City which comprises all the cities all over the world

Firstly, I put this statement on the dimension tab

if(city = 'london','london','Others')

This will tabulate two column, London and Others(All cities exclude London)

However, here is the twist,

My desired output is two columns with London and Others(All including London)

How do I derived this, kinda urgent. Thank you

[#2]

oh forgot to mention. The reason I use num() in the the last expression is because i generally do all my formatting within the expression.

The reason for this is that when you go to the number tab to format it only allows you to choose one format. When having a pecentage based value within the dimension, I will need to 'manually' format that one