How to display the sates data based on the zone wise

[ravindraa]

Hi all,

  I have one requierment that i have to display the data based on the state wise after select the zone.

i have Zone field and state field like below

Zone        State

Zone1       UP

Zone1       Bihar

Zone1       Orisa

Zone2       Tamilnadu

Zone2      Andhra

Zone2      Karnataka

Zone3     Gujarat

Zone3     Rajastan

Zone3      MP

I have crated the pie charts for all Zone's ,zone1 ,Zone2,zone3 ,if i select Zone1 chart it has to display the all corsponding states charts and like if i select the Zone2

it has to display the all corsponding state charts like for zone3 also ,it has to display dynmicaly in one sheet only .

please find the attachments.

please give me any suggesion on this.

thanks in advance........

[sundarakumar · Accepted solution]

Hi Ravindraa,

PFA the application where it has been implemented

The formula specified by textbox 1  will return the first state under the zone.. this is done with subfield function

u can cahnge the unmber to get the second and third values as specified in textbox2 and textbox 3.

Then u can use this to create a calculated dimension to show values only for that state as done in the bar chart..

Use conditonal layout to hid these if no zone is selected.

the main problem is we cannot be sure that each zone will ahve the same number of states, hence if a zone gets added with four states this is not good solution.

So i have added another sheet with a trellis chart.. this may fulfill ur requriement...

Hope this helps..

-Sundar

[ravindraa]

Hi Kalaimani sundarakumar,

  Thak you very much for your help i t is working fine .

Again thank you very much.

[sundarakumar]

You are welcome