How can i create such type of View?

Hello Everybody

I am in a problem. i am creating an application that keep records on sales. In my application there are various View and on these there are various Reports.

now in a View- Daily Report provide me the all over records of earning from the different locations op the today's date. It have following two fields:
Location and Earning

this view works well, and the report which attach with it also work fine but it's only provide me details where is sales happened. and if any location there is no sales or earning it is not included it in the report.

please look at example suppose i have 5 locations in the location drop-down field, now A, B and C having earning so in the View they appear, now my another location where no earning is done they didn't come in the view. Now how can i display them with a null value.
mean how can i attach them automatically in the view where there is no earning.

Mark