I have donwloaded the Top Item report from customer source but have a hard time changing it to what I would need.
Basically I am looking for a report that allows me selection by department, category, date range, plus the fields from the downloaded report.
However when running the report I would like to have quantities and amounts totalled by department, category, item number (rather then showing the individual sales per transaction).
Is anybody willing to share such a report?
Gerd
Gerd,
Are you looking at the correct report? The one you downloaded gives you the info you are looking for. The new report you downloaded should be in SO Manager | Reports | Custom | Top Items Report.
NOT the one in SO Manager | Reports | Sales | Top Performers | Top Items.
Make sure that you extracted the .zip file and copied it into your \Program Files\ Microsoft Retail...\Store Operations\Reports folder.
If you are seeing too much, try Collapsing the groups.
Hi Jeff,
I found my problem after reading your post. Actually I was looking for the results that report Top Performers -> Top Items already has. Just had to add my department and category and I was all set.
Thanks for pointing me to the right report.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required