How to change the Dimension of a table base on the selection.

[#1]

Hi,

How could i change the dimension of a table base on the selection from the list box.

Eg:

I have 2 values in a list box (A and B)

A & B are the fields in have.

I have another table with dimension A or B where the Dimension of the table has to change according to the selection made in the list box.

Thanks in Advance,

Baala

[swuehl]

Create a chart with both dimensions, A and B, and enabled conditionals (on dimension tab), something like

=substringcount(concat(ListBoxField), 'A')

resp.

=substringcount(concat(ListBoxField),'B')