How to do this?

[gauthamchilled]

Country  States           Rate

India      Delhi              5%

India       Mumbai          10%

India       Kerala               3%

To something like below in a pivot or straight table

India            Rate

  Delhi           5%

  Mumbai       10%

   Kerala          3%

[MK_QSL]

What is the Logic behind this? Please explain...

Otherwise you can take States as Dimension and use label as Country or India

[datanibbler]

Hi,

it would be helpful if you could elaborate a bit on what is this "this" which you're trying to achieve. That set of figures you have in your post could be interpreted in many ways ...

HTH

[alexandros17]

Take a look at this

[gauthamchilled]

Just wanted to change the header grouping from left side to top. Don't know how to say..its like

Country  States           Rate

India      Delhi              5%

India       Mumbai          10%

India       Kerala               3%

Australia   Sydney           8%

Australia   Canberra         4%

Australia     Perth              2%

I want something like the grouping below either in straight or pivot table.

Country     Rate

India

  Delhi           5%

  Mumbai       10%

   Kerala          3%

Australia       

   Sydney           8%

   Canberra         4%

    Perth              2%

[MK_QSL]

Create a Pivot Table

Dimension

Country

State

Expression whatever you want!

[struniger]

How about removing the country dimension, then naming the States dimension something like =only(Country)

Now when you select a Country from a list box you'll get your format.

[ankitbisht01]

If i am getting your requirements right it is like that , you want to see all the state under  country India ?

if this is the req. it is very to easy to make in pivot table.

PFA

Regards,

Ankit

[#9]

Use pivot with Charts

[gauthamchilled]

Anikit,

the one which you did is not my requirement...check my query above. yours is just normal pivot table with existing field name.