Detailed Item Sales Report

@JTRTech I remember a long time ago you made a Detailed Item Sales report.

I recently took that report and started playing with Pivot Tables. I think it’s coming out quite nice and it generates much faster because with Pivot you do not need to use parameters. I used Custom Product tags to define a ReportingGroup and SubReportingGroup for every product.

[!Item Sales:1,1,1,1,1,1]
>Report Group|Sub Report Group|Item Name|Portion|[N]Qty|[C]Sales
{REPORT ORDER DETAILS:MT.ReportingGroup,MT.SubReportingGroup,O.MenuItemName,O.PortionName,O.Quantity,O.ExactTotal:(ODI=True)}
5 Likes

It also has Portions.

2 Likes

[#Ürünler:4,5, 2, 2:0]
>Kategori|Ürün|[N]Adet|[C]Tutar
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
@{REPORT ORDER DETAILS:M.GroupCode,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
>{REPORT ORDER DETAILS:M.GroupCode,O.MenuItemName,O.Quantity.Sum.desc;#,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$1":{0}|{1}|{2}|{3}}
{REPORT ORDER DETAILS:M.GroupCode,'     '+[O.PortionName],O.Quantity.Sum.desc;#,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$1":2}

2 Likes

Great use of a Table View report. Pivot tables give a little more control over the data structure both allow conditional formatting.