1. At present, there is a pile of lists on hand. The fields are "time", "region", "point of sale", "product" and "product". They are grouped together under the condition of "point of sale". The practice on excel is very simple, PivotTable, in the row side of the five dimensions, the value on the "point of sale" field summation, can be achieved.
2. The current situation is that the data is more than 1.5 million and cannot be implemented in excel. In the case of mysql, you haven"t learned much before, only simple queries and basic group by statements, but you don"t know how to implement this situation where you need to present other field data in a conditional summary. Ask the gods for answers. Thank you.