Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
MEDHA07
Contributor III
Contributor III

how to show only data for where it has values

Hi All,

I need to get only the records for shipping id which location id has values.

Shippng id LocationNo BldgNo Amount
231 1 1 0
231 2 1 250
231 3 1 0

Output Expected:

Shippng id LocationNo BldgNo Amount
231 2 1 250
Labels (1)
4 Replies
BrunPierre
Master
Master

Sum({<LocationNo={"=Sum(Amount)>0"}>}Amount)

RsQK
Creator II
Creator II

Another option would be using formula:

Sum(Amount)

and under add-ons deselect "Include zero values".

barnabyd
Partner - Creator III
Partner - Creator III

G'day @MEDHA07,

I think I would convert all zero values in the load script to NULLs and then, in the table, exclude NULL values.

Cheers,

Barnaby.

Barnaby Dunn
BI Consultant
Chintam
Contributor II
Contributor II

Hi Harish, In addition to, you can use on the Base dimension in side the set. Like Shipping id, etc