Skip to Content
0
Jun 05, 2013 at 09:21 AM

Show values of a dimension in a unique cell

49 Views

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.