Data report: product sales not in one line (totalled)

[stephanhenning]

Report splits sales per transaction per item sold but I just need report to summarize total of all items sold.

e.g Brownies should be x3 in one line.

Here is my report:

[Report:1,1,1,1,1,1]
Department;Name;Quantity;Price;ExactTotal
@Bakery,Beer,Coffee,Coffee Equipment,Cold Drinks,Draught,Retail,Spirits,Wines
{REPORT ORDER DETAILS: 
  O.ItemGroup,
  O.MenuItemName,
  O.Quantity,
  O.Price,
  O.ExactTotal,
  :(MG=$1)
:"{0}";"{1}";"{2}";"{3}";"{4}"}
"$1 Total";;=SUM(C<row-{REPORT ORDER COUNT:(MG=$1)}>:C<row-1>)

THANK YOU!

[Bob_be]

Add .sumafter the quantity field. It should looks like this: T.Quantity.sum

[Posflow]

@stephanhenning

  O.Quantity,
  O.Price,
  O.ExactTotal,

  O.Quantity.sum,
  O.Price,
  O.ExactTotal.sum,

[YILDIZHANPOS]

https://kb.sambapos.com/en/9-1-6-custom-report-pivot-table-views/

[YILDIZHANPOS]