Hey everyone,
I have a query displaying total customers within specific sectors using the groupby and sum arguments. The only issue being it doesn't display sectors with 0 customers at all (i would like it to list them with 0 total). I just wondered if there was a way of doing this or whether it will only ever show results with positive counts?
Thanks so much,
Dave
I have a query displaying total customers within specific sectors using the groupby and sum arguments. The only issue being it doesn't display sectors with 0 customers at all (i would like it to list them with 0 total). I just wondered if there was a way of doing this or whether it will only ever show results with positive counts?
Thanks so much,
Dave