how to dynamically lable column in CUBE Based Cross Tab Reports

[shan1504]

I am having cross tab reports based on cubes having dimension geography.

Geography is having different levels as below

Zone-->State-->Region-->Depot-->District-->Taluka


In current report when i click on NORTH it goes to next level showing NORTH as column lable.
I want to display here STATE (column label) and below states(HARYANA,UTTARANCHAL,MADHYA PRADESH etc.), instade off NORTH which is next level of hierarchy of ZONE and so on for REGION ,DEPOT

example

current report

ZONE(column lable)
========
NORTH
EAST
WEST
SOUTH

when I click on NORTH it goes to next level showing NORTH as column label

NORTH(column lable)
=============
HARYANA
UTTARANCHAL
MADHYA PRADESH

I want to display here STATE (column label) and below states(HARYANA,UTTARANCHAL,MADHYA PRADESH etc.) , instade off NORTH

STATE (column label)
=============
HARYANA
UTTARANCHAL
MADHYA PRADESH