Sales Report [Category with sub menu items

[SHIELD]

I want a report to display Sales report in this format

Eg.
Soft Drinks
Coca Cola 10 50

Thus ;
ItemGroup
MenuItemName Price Amount

I tried the report below but not getting results
Can someone assist me please

Thanks

[Sales:5, 2, 2,1]
@{REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
>{REPORT ORDER DETAILS:O.ItemGroup,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.ItemGroup="$1"}
{REPORT ORDER DETAILS:’ '+[O.MenuItemName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$1":2}
>Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True)}

[JTRTech]

Have a look at this - might help;

Help with Report for Item Sales grouped by Menu item Group but with portion breakdown

I use this (perhaps its usefull for you too): [!Totales por Grupo con TAGS:2,2,2, 1, 1,1] >Grupo|Porcion|MenuItemName|[N]Cantidad|[C]Total|Status {REPORT ORDER DETAILS:O.ItemGroup,O.PortionName,O.MenuItemName,O.Quantity,O.Total,OS.GStatus} [image] Thanks!!! G.

I was having some issues if product names contained special characters or ‘and’ as effected the rendering/formatting of the data, emre debugged so should be fixed but use a report from later in the topic.

[SHIELD]

@JTRTech

[!Totales por Grupo con TAGS:2,2,2, 1, 1,1] >Grupo|Porcion|MenuItemName|[N]Cantidad|[C]Total|Status {REPORT ORDER DETAILS:O.ItemGroup,O.PortionName,O.MenuItemName,O.Quantity,O.Total,OS.GStatus

Hello Thank you for the support. I tried it. It works. Is there a way to keep it stayed after saving in report?

[JTRTech]

@SHIELD

Is there a way to keep it stayed after saving in report?

dont understand that sorry.

[SHIELD]

Hi Bro

Thanks very much. It worked