So, say we have a product and we want to compare its monthly sales from last year to this year. I imagine this is best done using some RMS report and exporting it so it can be imported into Excel.
What's a good RMS report to do this?
Thanks!
*This post is locked for comments
Thanks. Sounds like I need to starting learning what a pivot table is and how to use them! Before we got RMS, I barely used Excel, now I'm starting to get a bit more proficient—still a lot to learn though!
I suspect you are getting into the area of using Excel to link directly to the sql tables in rms. We use it quite regularly and use pivot tables and pivot charts for just this purpose.
Shane
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (