Get latest date and price in Month dimension
Can anyone guide me how to build and create line item formula to fulfil this requirement?
We have a flat data in excel, inside has date, product and price, the data can be entered and uploaded not in sequence, it means today i can upload for 6 Apr, tomorrow i can upload for 5 Apr.
I need a module then can shows the data by Month, indicate what is the latest date and price received for that product. Like the sample above, even though tomorrow i upload for 5 Apr, i still want to show 6 Apr because 6 Apr is the latest. Attached with a sample of input and expected output.