Show Data Without Null values and find Sum of sales for that data In FrontEnd Only

[ArjunChandra]

Hi to all,

I have Data like this in below Pics and My requirement is:

1) Want Customer name,Country,Product  in One table (Exclude Null Values only in FrontEnd, No suppressing).(Result should be All Rows or Records with data)

2)Want Customer name, Amount and Sales in another table. Find Sum of Sales and amount for that above Resulted Data(Data done in 1st Step). Only in Front End without Suppressing

3) How should I Exclude all Null data, What if I also have Null data in Amount and Sales.

PIC 1Pic 2