If you're using the [Inventory Turnover] report from the Jet Reports, Report Player you may be drawing the wrong conclusions because THE REPORT HAS AN ERROR IN IT. If you use the [Location Code] slicer, you may assume that you're looking at the inventory from THAT location; however, due to the design of the report, you're actually looking at inventory across ALL locations. Easy solution? Recreate the report in Jet Enterprise. At 40+ minutes, the tutorial is a mini-consulting session! But if you're strapped for time, I've included hyperlinks that function as chapter markers.
Use Excel's GetPivotData function: https://youtu.be/h2Si6xHmWbw?t=262 Show Calculated Fields in Pivot Tables: https://youtu.be/h2Si6xHmWbw?t=604 The Inventory Turnover Report IS WRONG: https://youtu.be/h2Si6xHmWbw?t=781 Building KPIs in Jet Data Manager: https://youtu.be/h2Si6xHmWbw?t=1107 Visualizing your cubes in Excel #PivotTables: https://youtu.be/h2Si6xHmWbw?t=1712 When Rollups make your KPIs 'wrong': https://youtu.be/h2Si6xHmWbw?t=1798 Visualizing your data in PowerBI: https://youtu.be/h2Si6xHmWbw?t=2293 If this is all greek to you and you want someone to review your existing Jet Enterprise implementation (there's a new update to Jet Data Manager) , give me a holler at jae@onyxreporting.com or shoot us a message through the website. Our team is available for training, development services and support remotely as well as onsite!
0 Comments
Your comment will be posted after it is approved.
Leave a Reply. |
Categories
All
|