Hello,
My coworker and I are trying to create a Board that will serve as a "one stop" landing page. We are showing a summary of Current On Hand and On Order by selected department. We are hoping to be able to return a list of Purchase Orders that match the item and department that has been selected thereby allowing users to drill down the On Order to the actual Purchase Order/Line. I feel like we have all the data we need, but we just are having trouble connecting all the dots. Has anyone else successfully accomplished this or something similar?
Thank you!
Tricia