hi there,
there are a couple of ways to do it as long as the dimensions are the same for all tables...
1. have one table with all the expressions for each listbox selection. then make the expressions enabled conditionally, by selecting "Conditional" right next to "Enable".
For each expression, use a condition something like getfieldselection(ListboxField)='Field1', etc. corresponding to the listbox selection. the table will update in response to list box selection. of course, if you have more than 3-4 list box values, this method becomes tedious very quickly.
2. as long as the field names are in a particular format, then you can concatenate the selection in the field box and display data dynamically within the same table.
what i mean is...let's say in a table your expressions are sum(Sales for ABC), sum(Orders for ABC) and ABC is a value selected from a listbox...the expressions in the table can be written as sum($vSum) and sum($vOrders)
where vSum = '[Sum for '& GetFieldSelections(Condition)&']'
and vOrders = '[Orders for '& GetFieldSelections(Condition)&']'
the values will update for listbox selections ABC, DEF, XYZ, etc. this was the case in one of my requirements...obviously, modify it to suit yours.
Of course, this method will need your field names to be in a particular format.
post a sample qvw and i can help you if necessary.
