Selection in two list box

[soha1902]

Hi All,

I am trying to implement Hierarchy in my dashboard. I created two excel, one for Dimensions and another one for Metrics. Hierarchy is coming in list box without any issue but when I select a value from dimension then metric selected value got deselect and vice versa.

Please se below screen shot: can anyone suggest me why I am not able to select both values at a time?

Thanks

[sunny_talwar · Accepted solution]

Have not worked with Hierarchy before, but it seems that if you rename one of the Hierarchy to something like Hirearchy_Metric, the selection in one won't impact the other.

This is the problem you have right now:

[swuehl]

Right, you would need to create two data island tables to be able to make completely independent selections in dimensions and metrics.