Need to display only two dimensions at any point of time

[musketeers]

Hi,

I have straight table in my dashboard where I am displaying few data. In this I am displaying dimensions based on user selection from Dimension list I have created in the dashboard.

Now if user select any dimension from Dimension list box, I am displaying the value of that dimension in straight table and corresponding measures.

My requirement is that I have to display only two dimensions in straight table. For example:

If user select Dim-1 and Dim-2 from Dimension List Box, I will display the values of Dim-1 and Dim-2 in straight table.

Now if user select Dim-3 from Dimension List Box, straight table will not display the values of third selected dimension.

Is there any way we can achieve this.

Thanks

[sunny_talwar]

Exact dynamics might need to be tested, but you might be able to add a third condition to to your dimensions, something like this -> GetSelectedCount(ListBoxWhereYouSelectDimensions) = 2

[Gysbert_Wassenaar]

Use two list boxes (or a multibox) and let the user select only one dimension in each of the list boxes by using the Always One Selected Value option. Use the dimension selected in the first list box as the first dimension as the second dimension in the straight table and the dimension selected in the second list box as the second dimension in the straight table. You could load the dimensions table twice in the script, once for each list box. Or you could use alternates states and assign a different alternate state to each list box so that a selection in one list box doesn't affect the other list box.