I have the sales base table which contains the date of sale, brand, amount. I run it as follows:
for each ventas
where FechaVenta=&fecha
&montoTotal=&montoTotal+ monto
endfor
With this I manage to obtain the total amount per day; but I need to obtain the amount by brand and date, and the result is more or less like this:
Fecha Marca - Monto
01/12/21 VW =900,000,000.00
01/12/21 Nissan =200,000,000.00
01/12/21 Ford =900,000,000.00
First of all, Thanks