Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi,
Above set analysis is AND condition not or.
Can you check your data again or possible attached your app here?
Regards,
Sokkorn
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.
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
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
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.