Hi everyone!
I have a query there, associated with one table.
One column is the year, the next is the specific month, and the next columns are the cities with the number of brands associated to the respective city. My problem is that I can't seem to be able to count unique brands for each city. It only counts the sum of them. For instance, for the city of Seattle, by manual count I get 127 brands, but the query Count shows me 169 brands.
Cheers!