Combine Different columns into listbox

[joejobs]

Hi Everyone, 

How do I combine different columns into one dimension for a list box. 

So I have data in the form:

Customer_ID	Current_Account	Savings_Account	Loan_Account
1001	1	0	1
1002	0	0	1
1003	1	1	1

For each account, 1 or 0 represents the customer having the account or not. 

I want to populate a listbox of account types with the contents

Current_Account

Savings_Account

Loan_Account

So on click of any of the options, all customers that have the the account type are filtered, and vice versa.  Is this possible please?

[StarinieriG · Accepted solution]

Hi

you could do it using crosstable 

After that, you could filter your data adding where value = 1