cancel
Showing results for 
Search instead for 
Did you mean: 

Show values of a dimension in a unique cell

0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Mario,

here a blog with a step by step guide:

http://bi.srivatsakr.com/2011/08/converting-rows-into-single-cell-comma.html

Best regards,

Victor

Answers (2)

Answers (2)

former_member189638
Active Contributor
0 Kudos

Right Click on the table and select Format Table. Then check the Show Table Footer Option.

Now in the Footer for Inv just put SUM([Inv]).. This will give the total of Inv

For City, use the below Formula in the Footer Cell.

=Replace(ReportFilter([City]);";";" ")

You can use the similar formula for other columns as well in the Footer cell.

Former Member
0 Kudos

Hi Mario,

As far as I am aware, you can arrive at the summarized value for all cities (9000) if you ignore the city dimension and day dimension from the default context of the second table shown in your description.

=[Inventory] ForAll([City];[Day])

Coming to City showing the concatenated values of all the cities that are contributing to the inventory in block may not be possible in webI, but possible in Excel if you can transpose City column into Row and concatenate the row values.

You can show the transposed and concatenated City object to achieve your requirement

Thanks

Mallik