We are running a report that is giving us the data back that we want but we would also like the following:

The data is being returned in weeks... but without blank data being shown ie. 

We would also like it to show the week ending date

showing at the moment:

week 1      week 2      week 4       week 8

£80            £97            78            £87

What we would like it to show

07-Jan-16            14-Jan-16            21-Jan-16      28-Jan-16

£80                        £97                       £0                  £78

 

Could anyone advise on how we achieve this please?     

I should also add that the data for this is coming straight from ZOHO CRM.

Many thanks

Guy