on 06-05-2013 10:21 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.