how to show only data for where it has values

[MEDHA07]

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

[BrunPierre]

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

[RsQK]

Another option would be using formula:

Sum(Amount)

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

[barnabyd]

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.

[Chintam]

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