Show values of a dimension in a unique cell

Hi,

Let's consider the following example:

Month Day City (dimension) Inv

june 1 Madrid 3000

june 2 Sevilla 2000

june 3 Valencia 2500

june 4 Granada 1500

I would like to obtain a total row as follows:

Month City (dimension) Inv

june Madrid Sevilla Valencia Granada 9000

Does anybody know how to do this?

(I am reading information from a xls file)

Thanks a lot!!

Best Regards,
Mario.