Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
Please post sample qvw that shows what you are trying to do.
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.