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