Removing data row based on condition

[user467341]

Hi all,

I have created a pivot table, as an example below:

I will need to remove the data where the "Level" has "Out" (as you can see, work A is duplicated in price because of the "Out").

I tried the set expression:

=Aggr(Only({<Level-={"Out"}>} Level), Level)

But the result is this:

The "Out" is removed, but the data row remains.

I need the end result to be:

Any help or advice on this is greatly appreciated. Thank you.

[vinieme12]

on the Level Dimension uncheck Include Null Values

[user467341]

Hi, if I do that then my work "C" will also be gone. Please see my end result table...

Thank you.

[ogster1974]

add your set analysis

{<Level-={"Out"}>}

to Price instead

[user467341]

Hi it does not seems to work.

My price has a formula using SUM(X) in set analysis.

[ogster1974]

{<Level-={'Out'}>}

Works for me