Adding a new column in crosstab

Hi all,

I have a crosstab where in rows display data that is grouped by countrys (country name) and columns are grouped by product names.. the summary field is actually the count of products.As of now everything is working fine.

My requirement is to have another column basically displaying data that is not grouped to the existing column (ie product names) .. instead it displays count of cities in the corresponding country,average sales amount etc..

I am not able to add these columns into the cross tab.. can anybody tell me how to achieve this feature in my report?

Thanks in advance,
Abdel Olakara

Find more posts tagged with

Comments

mwilliams

Hi Abdel,

Can you not add these values as measures in your dataCube to get them in the crosstab that way?

Abdel

Yes that is possible, but the problem is it will come under the existing column grouping right? Currently my column is grouped by brand and products.. and the measure is the sales count for each product.. now i need a common column that is not under the grouped column

eg:
B1 B2 | C1 | C2 |
P1 P2 P3 | P1 P2 P3 | | |
item 1 | 5 1 2 | 5 1 2 | | |
item 2 | 2 3 1 | 5 2 2 | | |

I am trying to get C1 and C2 columns.. Any ideas?

mwilliams

Abdel,

I'm not sure that there's a good way to achieve this. There may be a way to use a joint dataSet with an outer join and computed columns to merge the data columns to get the data in, but I'm not sure that it'd work out exactly how you're wanting. I haven't tried it yet, so maybe it would.