my boss asked me to make a sheet in which there are two tables with the same field(for example NetSalesAmount). but they are different in time period(and this differential is not a static one). in fact he wants to be able to set time period for each of tables and compare them. do you know how it is possible?
This is only possible by Alternate state,Got o settings-> document properties,click on alternate state and add two state there State1 and State2.
then go to your one list box and set its alternate state state1 and go to your table properties and set its alternate state as State1 now this two objects are related to each other selection of this list box only reflected by this table.
do the same for second list box and table and set their state as State2.