Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I have a probleme in my document : I load 3 columns with 2 values for each.
| Name | Salary |
|---|---|
| Alex | 500 |
| Chang | 1400 |
| Romain | 1500 |
I make a graph-table with an expression like that :
| Name | Salary | Group |
|---|---|---|
| =Name | =Salary | =If(Salary>1000,'Group1',Group2) |
| Alex | 500 | Group1 |
| Chang | 1000 | Group2 |
| Romain | 1500 | Group2 |
I would like to make a listbox which present the two possible value which are generated by the "group column expression" (=If(Salary>1000,'Group1',Group2))
My user select Group1 on a list box and the table is refresh with only the Group1 value.
Thx a lot
Put your formula: =If(Salary>1000,'Group1',Group2) in the expression.

Thx very much