Many to one relationship, how to show as 'other' not blank when value in the 'one' table not found

[Anonymous]

Hi Guru,

I have 2 tables in a many-to-one relationship.

first one is transaction table,

second is Customer table that has 2 columns - Customer Group     and    Customer Account #

Relationship is on Customer Account #

When I slice the transaction table by Customer Group,

All the accounts that don't exist in the Customer table would appeared as blank,

Is there any way to show the blank as 'Other'?

[amitchandak]

@Anonymous , I doubt that, better make sure dimension has all values