Maintaining a value despite a filter

[sallemongp]

Hello,

First of all, thank you to those who will answer me.

The goal here is to keep the value of a "mother line" unchanged. While a filter will be applied to the items that compose it:

A quick exemple below:

Actually i have a dataset like this.

I would like to don't have the first row and have my expected value (and weighted value) on the filtered Item.
And in the case where there is no filter i woul like these value on the first Item.

Actually i can only have this:

I have just create a table with only the expected and the ID and a table with the ID, The Item number and the quantity.
And i have attribute on the Item number 10 the Expected value.

However if i put a filter on the Item 20, 30 ... I naturally have an empty field for the expected

Any suggestion ?

Thank you in advance.

[v-danhe-msft]

Hi @sallemongp,

From your description, I could not understand what your want? Could you please post your desired result if possible?

Regards,

Daniel He

[sallemongp]

Hi V-Danhe,

I would like something like this:

 

And when I tick the item 20, 30, 40 ..... I would like to  keep the expected.
Actually this work only when i tick the item 10.

(I don't want to have the expected value on each row when no filter is ticked because for the users that could be disturbing)

My apologies if I'm not clear in my explanations.

Thank you in advance

[v-danhe-msft]

 Hi @sallemongp,

From your data structure, I am afraid you could not achieve your excpeted result, due to there is no data related to item 20, 30, 40... in excpeted column, so when you chose the other ietm, the result should be blank.

Regards,

Daniel He