Expression only show null values in Pivot Table

[khaycock]

I need an expression that only shows BIN where the QUANTITY = 0? I don't need any other fields to be displayed.

What kind of expression do I need?

[Anil_Babu_Samineni]

You mean to say this?

Only({<QUANTITY = {0}>}BIN)

[sunny_talwar · Accepted solution]

May be like this

Dimension

Bin

Expression

If(Sum(Quantity) = 0, 1, 0)

[khaycock]

When I use this as an expression, it returns the same amount for the BIN and the expression. I tried it as an dimension and it didnt work

[khaycock]

This is just displaying 1 for everything? I only need to show BINS where the QUANTITY = 0?

[sunny_talwar]

Really? Even if use this if statement which says that only show 1 when Sum(Quantity) = 0, assign a 1, else a 0? Can you share an image after adding another expression

Dimension

Bin

Expression

If(Sum(Quantity) = 0, 1, 0)

Sum(Quantity)

[Anil_Babu_Samineni]

Can you show the image, And explain the result

[khaycock]

Oops sorry that was my fault. You're right, thanks!