Selection

[n1ef5ng1]

Hi gurus,

I have this particular table where user have the option to select which Group_Country field or Group_Region field they would want to look at.

If user select Indonesia, the data will show as of Indoensia perspective

and if user select Asia, the data will show as of Asia perspective.

This is my code

((sum({$<TXIT_Group_Country.Load ={$(=(Group_Country))} >} Transit_TEU) )

Group_Country is a field for user to select the countries from

However, I would want the tableto be dynamic in the sense that it will detect whether user select country or region field before displaying out

I tried methods such as

((sum({$<TXIT_Group_Country.Load ={$(=(Group_Country))},TXIT_Group_Region.Load ={$(=(Group_Region))} >} Transit_TEU) )

((sum({$<TXIT_Group_Country.Load ={$(=(Group_Country))} or TXIT_Group_Region.Load ={$(=(Group_Region))} >} Transit_TEU) )

but it does not work.

Any help, thanks

[tresesco]

Can this be a simpler solution ?

Create listbox with the following expression : =If(TXIT_Group_Region.Load =Group_Region, TXIT_Group_Region.Load)

And allow user to select from this list box.

Assuming that, TXIT_Group_Region.Load is a superset of Group_Region

[#3 · Accepted solution]

I think you could use the option of conditional visualization of the table. In the design tab, select conditional showing:

Then, in the textbox, you could write down the condition you want to apply. In your particular case, if you want the table to be shown only when one country or one region is selected by the user, it should be something like:

getSelectedCount(Group_Country)=1 or getSelectedCount(Group_Region)=1