Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

last 5 weeks of data from history

Hello all,

I am using BEx as data source and we have last 10 weeks of Quantity as below:

CountryMaterial28.201429.201430.201431.201432.201433.201434.201435.201436.201437.2014Total
CountryAMatA106101036362359
MatB331532102106256
MatC2262636615553
MatD858582886260
MatE464645448348

I am expecting top 3 materials on quantity for last 5 weeks of data only as as below.

CountryMaterialQuantity
CountryAMatC35
MatB30
MatD

26

FYI,

below is the 5 weeks of data from given above 10 weeks of data.

CountryMaterial33.201434.201435.201436.201437.2014 Total
CountryAMatA6362320
MatB102106230
MatC36615535
MatD2886226
MatE5448324

Question is how to restrict quantity to last 3 weeks from given 10 weeks of data

Thank you,

suri

Former Member
Not what you were looking for? View more on this topic or Ask a question