How to show only the last uploaded data from a module in a dashboard
Could anyone please help me to implement a requirement?
We are getting a monthly file from various manf. locations that tells the available inventory bucket values for various product lots. Here is a sample of the file we are getting
I am loading the file every month to a Data module dimensioned by Manf.Location, Product Lot and time ( month scale). In a dashboard I need to show a static report that always show the last uploaded data (ie. oct 2020 till another set is uploaded next month). The report format needed is like below
User should be able to Select a Lot# and then it should show the last uploaded data like this
Thanks for your help...