sum case
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
