Report Help

Jan 14, 2008 1 Replies

I'm looking for some report modification help. I have a report "Profit Report by Category (YTD, MTD)" which I would like to customize.


  1. I would like it to show all categories even if the sales are zero.
  2. I would like to show the current in-stock value (wholesale and retail)
  3. I would like it to show in-stock unit quantities.
  4. I would like to add the department column.

Any help would be appreciated.


Hi there,

Retail Analytics from Professional Advantage will enable you to get all of the information you are looking for. Retail Analytics for Microsoft RMS 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. A few examples of measures our customers analyze include: Margin, Revenue, Sell through rates, Cost of Goods Sold, Tenders, Those measures can then be viewed and compared by different dimensions such as: Category, Store, Salesperson, Department, Item Matrix Fields, Item, Supplier Date/Period.

If you would like to take a closer look at the product, we have a quick movie available at

formatting link
Please contact me if you have any questions or if there is anything that I can do for you.

Jen Bridgeford snipped-for-privacy@profad.com

701 235 2363 ext 248

"RMS" wrote:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required