Problem with filter selection

[valnod_90]

Hi everyone,

i have a problem with a filter pane and a table.

I think is not easy so i'll try to be as clearer as possible.

The filter contains all the features of sell orders, the table contains all the sell orders.

When i select from the filter two or more features i'd like to see in the table, as result, only the orders that have all the features that i've selected at the same time.

That's the point, i need to have alla the features simoultaneously.

So, for example, if i select as color, from the filter pane: green, red and yellow, in the table i'd like to see an order ONLY if it has all the three features togheter, or nothing.

If i select six features i'd like to see an order only if it has all the six features or nothing, and so on...

Is there a way to do it?

[niclaz79]

Hi,

Can you explain your data model? Can an order have multiple features? are the features all in one column etc?

This is hard to explain how to do without knowing what your data looks like.

[shanky1907]

Did you try the below approach:

If the expression in your table is like Sum(Sales).

Try this:

Sum{<Color=p(Color)>Sales}

[valnod_90]

I'll try, the data model is quite easy because is just a table with columns and rows.

An order has more features and these are all in a single column of the table.

You can imagine a column with the number of the order and a column with the features, that's all.

[valnod_90]

unfortunately i don't have any expression in my table but just dimensions

[shanky1907]

Tale table chart(not table box) as the object.

Then Take color as expression and try with above expression plz

[valnod_90]

I tried but it doesn't work.