How to combine multiple fields in a listbox?

[#1]

Hi everyone,

I have a source table like this:

Employee	dogs	cats	horses

and want to have a listbox as a filter like this:

Animals

------------

dogs

cats

horses

rabbits

...

so that it returns all employees with cats, if I press cats in that listbox.

I tried it with

=if(cats='x',dual('cats',1),

if(dogs='x',dual('dogs',2),

but this ended up in garbage

any idea?

[sunny_talwar]

Have you thought about using CrossTable Load?

The Crosstable Load

[#3]

Hi,

You need use cross table.

Load your source table then advance -> advance and do this:

After that press ok and reload.