Second Dimension display issue in 2-D Bar Graph

[#1]

Hi All,

I am facing an issue in 2-D Bar Graph.

In the graph currently all the values of Second Dimension (city)are getting displayed for each values of First Dimension(Country).

I am attaching a screen shot .Ideally under country only cities which belongs to that country should be  displayed.

Under India only Indian cities should be displayed and same with the rest .

Can some one please help me in this ?

Thanks

Srawan

[#2]

what does your data model look like.  Since it sounds like we need to know how data is related (city to country) there should be something to indicate relationship - such as each city has a country.

can you attach the qvw

[#3]

Thanks for the response .

Please find the attached QVW.

Thanks

Srawan