I've received a request these days and I was unable to deal with it.
I've asked to do a price analysis. During the sales period, our company can sell the product by various prices, dependeing on the moment. What I need to do is classify the prices by the max, the min and others. After this, we want to know how many units we sold, the total sales value, cost value by this classification. The results should be like the excel "resultado".
I've attached an excel file with a sample of the data, and the app I started to develop.
Thanks in advance.
Márcio Rodrigo Campestrini