How to remove Row with null value ?

[paulyeo11]

Hi All

I like to count how many company sales go up, but the count also include those company sales =0 ,

As my column data also capture those sales = 0 , may i know how to remove those row which have 0 value ?

Now my Table have 50 Row , how to keep only 1 to 19 row ? As after 20 row all are null value.

Paul

[paulyeo11]

Hi Tamil

Thank you very much , it work fine . How about help me on below :-

How to make my Table Total amount display same value when my dimension change from COMPANY TO SOURCE...