How can i achieve tis in Bex Query Designer
Please advise on how can i achieve this in Query.
I got Location,Material_ID,Price and Change_Date.
(Change_Date is defined as both CHAR & KF in cube)
(Change date is on monthly basis they execute a programe in non sap source system to update the prices of material)
The Price of material tends to change or may not change ...
Every month we get a record from source system on material price
My requirment is to bulid a report that show
Material_IDCurrent Price and Previous Price
Please advise how can i develop this report