Select() specific rows from a slice

[Snail]

Hi,

i have a question relative to the use of select() function from a slice.

I have different tables « data », « filter », « dashboard ».

i have created a slice « data_filtered » based on the input from de « filter » table. It works well.

then, I would like to create a « dashboard » from the data_filtered slice with the use of select().

my dashboard table has a virtual column « profits » which has this kind of function:

Sum(select(data[profits], [category]=[_THiSROW].[category_select]))

it works well. However I would like to use the slice « data_filtered » instead of the data, and by changing data[profits] in data_filtered[profits], it does not work.

any idea?

[Marc_Dillon]

by changing data[profits] in data_filtered[profits], it does not work.

---

That should work. How did it not work?

[Snail]

I do not not know. However the results of the formula is empty