Chart Presentation

[#1]

Suppose i have two fields in dimension tab ie.

State and city

Maharashtra            pune,mumbai

Bihar                       patna

uttar pradesh           lucknow,allahabad,kanpur,noida

punjab                    ludhina,chandigarh

And in expression tab i have sales

Now i want show the chart as

MAharashtra        Pune               sales

                         Mumbai

UP and Punjab   lucknow

                         allahabad          sales

                         kanpur

                         noida

                         ludhina

                         chandigarh

Here sales is individual city sales

[#2]

Hi ,

You can use straight table which will display data as required .

[jagan]

Hi,

Use Pivot table, with State as first dimension and city as second dimension.  Now use

=Sum(SalesFieldColumn) as expression.

Hope this helps you.

Regards,

Jagan.