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
You can do them by nesting For Each and making control breaks
The navigation should always show you tours on the sales table, showing the nested ones as "break"