Dimensions not filtering with variable

[jalanhart]

Hello, 

I have a variable that sums a field filtered down by certain dimensions. Currently I have a measure in the table which uses a pick(match) that applies set analysis measures based on the variable button selected. 

Example here Sum({<TRANSACTION_CODE = {'OESHIP','SHIPTRAN'}>} QUANTITY)

The issue is that when this button is selected, it still shows other codes with a 0 in the measure column. I do not want remove the zeros through the data handling because that could filter too much. 

The table should only show rows with OESHIP and SHIPTRAN but it's showing more than that. 

How do I get those rows to NOT show up based on a variable selection?

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[Anil_Babu_Samineni]

Perhaps try this?

Sum({<TRANSACTION_CODE = P({<TRANSACTION_CODE = {'OESHIP','SHIPTRAN'}>} TRANSACTION_CODE)>} QUANTITY)

Or

Sum({<TRANSACTION_CODE = {"=Sum({<TRANSACTION_CODE = {'OESHIP','SHIPTRAN'}>} QUANTITY)>=0"}>} QUANTITY)

[morgankejerhag]

Go to the chart settings -> Add ons -> Data handling -> untick Include zero values

[Chanty4u]

Try this 

=If(Match(TRANSACTION_CODE, 'OESHIP', 'SHIPTRAN'),

      Sum({<TRANSACTION_CODE = {'OESHIP','SHIPTRAN'}>} QUANTITY)

)