Multiple Dimensions concatenate as one dimension

[#1]

Hi,

I have the following table

Region     District

RA          D1

RA          D2

RA          D3

I want to make a bar chart which will have the following dimensions:

RA,D1,D2,D3

I tried using valuelist but it is showing "ERROR IN CALCULATED DIMENSION"

Thanks

[Gysbert_Wassenaar]

Create a new field in the script and use that field as dimension:

Load Region as ReportRegion, District Inline [

Region,     District

RA,          D1

RA,          D2

RA,          D3

D1,          D1

D2,          D2

D3,          D3

];

[jonathandienst]

Please post sample qvw that shows what you are trying to do.

[#4]

Thanks gwassenaar for the reply.

The intention is to select a sales hierarchy and then compare values with both upper and lower hierarchies in a bar chart.

I already have a dimension table which has the mapping for region,district and area. Is it possible to get the said requirement by using a calculated dimension?

^

|

|                                   __          __

|    ___                        |     |     |        |

|    |     |        ____       |     |     |        |

|    |     |        |     |        |     |     |        |

|__|__ |____|__ |____|__ |__ |____|________________>

     Nation     Area     Region  District

This is how the chart is supposed to look if I select 'Region'.

Hope I am clear.