how categorical variables can have a numerical total of another numerical variable?
for example i need sum THE TOAL OF SALE FROM DIFERENT BRANDS / TOTAL OF SALES.
the query needs to be smart enough to determinate the different brans
AND IN A GRAPHIC THE BRANDS NEED TO BE IN X AXIS AND % IN Y AXIS