Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys. I have a problem I'm trying to figure out. I've got a table that includes two similar record types with a "Record Type" field.. I want to be able to filter each record type independently. The way I do this now is to split the table into 2, but this has doubled the amount of dimension tables required.
So say I have a filter of Color, with possible values red, yellow, and green. I want to create one list box that will filter ONLY records of type A by color, and another that will filter only type B by color. So both list boxes will say red, yellow, and green, but when I select Red on list box A, it will filter those records of type A, but records of type B will remain in tact. Then, I can select Green in list box B, and it will filter records of type B, but leave type A in tact. So the resulting data set will be one table with records of Type A with color Red and records of type B with color Green. This is easy to do if I have 2 separate tables, but is it possible to do with one? Thanks for the help!
Hi,
Please see the attached application. I am not sure , whether this will match with ur requirement.
- Manish
As I understood you want to select values from a listbox using code or macro!
if you click on Settings->Document properties then select Triggers tab there you can find something called field trigger from there you can add a macro and put a condition on what to select from another listbox
I attached a sample document and hope it helps
Hi t_eweiss,
It's really difficult to understand for me (from Argentina), but if i do it right, you have to create a calculated dimmention in each listbox:
=If(Left(Type&Colour,1)='A',Colour)
But... This wil select, for the Type A, only the Colour you select on the ListBox, but it will exclude all other Types.
Then, you must to create 3 auxiliar unlinked tables. Like TypeA_Colour, TypeB_Colour and TypeC_Colour tables, with A_Colour, B_Colour and C_Colour field each one.Then the expression would be:
=Sum ({$<Colour={=$(Concat(A_Colour,', '))}, Type={A}>} +
Sum ({$<Colour={=$(Concat(B_Colour,', '))}, Type={B}>} +
Sum ({$<Colour={=$(Concat(C_Colour,', '))}, Type={C}>}
This way, each Sum will filter, only for their Type, the field Color you have selected in its listbox.
Sorry for my poor english!!
Sebas
Does it helps you?