Average Sales per Store

Hi Jason,

If you are interested in custom reports , please drop a email to discuss further.

Regards, manick snipped-for-privacy@hotmail.com

"Jas> One other thing that may be useful is if it can summarize by date also -

hi Jason,

open the file in notepad and do the following changes after INTO ViewStoreQty and repalce this

FROM [Transaction] LEFT JOIN TransactionEntry ON [Transaction].TransactionNumber TransactionEntry.TransactionNumber LEFT JOIN Item ON TransactionEntry.ItemID=Item.ID LEFT JOIN Department ON Item.DepartmentIDÞpartment.ID LEFT JOIN Category ON Item.CategoryIDÊtegory.ID GROUP BY CONVERT(nvarchar, [Transaction].Time,

Then go below the code and before at the End ReportSummary section you will see GroupBy: replace with it: GroupBy = "VIEWStoreQty.DeptName,VIEWStoreQty.CatName"

Now go again below the whole file and add this: Begin Column FieldName = "VIEWStoreQty.DeptName" DrillDownFieldName = "" DrillDownReportName = "" Title = "Department" VBDataType = vbString Formula = "VIEWStoreQty.DeptName" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2595 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "VIEWStoreQty.CatName" DrillDownFieldName = "" DrillDownReportName = "" Title = "Department" VBDataType = vbString Formula = "VIEWStoreQty.CatName" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2595 GroupMethod = groupmethodNone ColFormat = "" End Column

Run the report have the date paramter already there so what you wanted to change.

"Jas> Need help modifying the RMS "Average Sales per Store" report that is found in

hi Jason, sorry I mistakenly copied the half portion of query here is full code: SELECT CONVERT(nvarchar, [Transaction].Time, 101) as DayOfYear, SUM(TransactionEntry.Cost*TransactionEntry.Quantity) as TotalCost, SUM(TransactionEntry.Quantity) as TotalQty, Department.Name DeptName,Category.Name CatName

INTO VIEWStoreQty

FROM [Transaction] LEFT JOIN TransactionEntry ON [Transaction].TransactionNumber TransactionEntry.TransactionNumber LEFT JOIN Item ON TransactionEntry.ItemID=Item.ID LEFT JOIN Department ON Item.DepartmentIDÞpartment.ID LEFT JOIN Category ON Item.CategoryIDÊtegory.ID GROUP BY CONVERT(nvarchar, [Transaction].Time,

"Jas> Akber,

Hi there,

Retail Analytics, from Professional Advantage, is designed to help retailers manage their business by delivering analytical reporting on business performance. Easily identify trends, buying patterns, seasonality, and other key performance indicators for your business. If you enter it in RMS you can report on it in Retail Analytics.

If you would like to take a quick look at the product, please go to

Please do not hesitate to contact me if you have any questions or if there is anything that we can do for you.

Thanks,

Jen Bridgeford

"Jas> Need help modifying the RMS "Average Sales per Store" report that is found in