Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My requirement is following. Let’s assume the below data.
State
HR |
MH |
City
HR-Chd |
HR-Roh |
MH-Mum |
MH-Pu |
MH-Nag |
Town
HR -A |
HR –B |
MH-A |
MH-B |
MH-C |
Table Box Data:
AA | BB | CC |
HR | AA | State |
HR-Chd | BB | City |
HR-Roh | CC | City |
HR -A | DD | Town |
HR –B | AA | Town |
MH | BB | State |
MH-Mum | CC | City |
MH-Pu | EE | City |
MH-Nag | GG | City |
MH-A | HH | Town |
MH-B | CC | Town |
MH-C | AA | Town |
If I click on Listbox (State) value = HR, then the data would be display like below:
AA | BB |
HR | AA |
If again I click on Listbox (City) value = HR-Chd, then the data would be display like below:
AA | BB |
HR | AA |
HR-Chd | DD |
If again I click on Listbox (City) value = HR –A, then the data would be display like below
AA | BB |
HR | AA |
HR-Chd | DD |
HR –A | DD |
To achieve this functionality, I put event field trigger on ListBox selection (CC field).
If I am selecting the data from Listbox one by one, the data is displaying correctly in Table Box. If I go from TableBox to ListBox then the data is not displaying correctly. I am getting other data which is not based on the filter in the Table Box.
If I click on HR value from Table Box Data:
AA | BB | CC |
HR | AA | State |
HR-Chd | BB | City |
HR-Roh | CC | City |
HR -A | DD | Town |
HR –B | AA | Town |
MH | BB | State |
MH-Mum | CC | City |
MH-Pu | EE | City |
MH-Nag | GG | City |
MH-A | HH | Town |
MH-B | CC | Town |
MH-C | AA | Town |
Then I am getting the below data:
AA | BB | CC |
HR | AA | State |
After that, if I click on Listbox2(City) value = HR-Chd then the above mentioned data gone and I am getting all the data belongs to City but I want only the below mentioned data in this case.
AA | BB | CC |
HR | AA | State |
HR-Chd | BB | City |
I need to display the data based on the Hierarchy. Can you please let me know what I am missing and how to achieve this functionality?
Thanks & Regards:
Amit Jain
I'm not sure and if i'm wrong maybe an expert can correct me.
What you can do is, add the following conditions to your dimensions
If (AA=AA,0,CC) >>> For AA Dimension
If(BB=BB,0,CC)>>>> For BB Dimension
the above 2 conditions should be given in your chart. Not in your List Box.
So if you select a value from List box 'AA' , EX: HR then it will show you all columns but not CC
CC will be hidden and will only be visible upon selecting the AA or BB value in your table..
Here we're hiding the CC column from users and will be available upon selection.
Make a Straight table, it will be better for users. All values will be visible regardless of selection but upon selecting filters AA of BB the CC will hide.
Thanks.