Pivot table + Conditionally Hide Rows

[Joaquin_Lazaro]

Hello:

I've a pivot table with one dimension Warehouse and three expresions Input, Output and Stock.

I don't want to show rows (warehouse item) where Input = 0 and Output = 0 and Stock = 0. How can I do it?

Thank you.

Joaquín

[Joaquin_Lazaro]

Hi Sokkorn Cheav

I have a little problem, with your aggr expression you suggested if Input=0 or Output=0 or Stock=0 the row is hidden.

What I expect is to hide row when Input=0 and Output=0 and Stock=0.

Please, I need more help.

[Sokkorn]

Hi,

Above set analysis is AND condition not or.

Can you check your data again or possible attached your app here?

Regards,

Sokkorn

[Joaquin_Lazaro]

Hi:

The negation is the problem. Now we only show when every column <> 0.

I want to show where one of the expression is <> 0 ... or I want to hide when all the expressions are = 0.

[Joaquin_Lazaro]

Hi:

I think these images will explain better the problem.

This image is before aggr. The dimension field is Descrip with title Almacén(=Warehouse) with all the zero values; I want to hide row 6 because all the expressions are = 0.

If I apply the calculated dimension the result is not what I expected because only show rows with all

the expression are <> 0

[Sokkorn]

Hi,

How many expression you have? You need to apply all expression into calculated dimension.

Ex. I found expression [Stock Transition] then we need to add

Aggr(Only({$<Input -={0}, Output -={0}, Stock -={0}, [Stock Transition] -={0}>} Warehouse), Warehouse) and so on.

Regards,

Sokkorn

[Joaquin_Lazaro]

I know ... but if I add [Stock Transition] -={0} the result is wrong, because hide all the rows.

The construction of set analysis will be one of the next:

1) Hide where all expressions equals 0

2) Show where one of the expressions is not 0

Now, we are showing all rows with all the values are not equal 0, just the opposite I want.