Here I would like to share one of my tech. requirement in Bex query, your inputs are much appreciated -
Scenario - In report I want to show "Sales for Last two days of week". I elaborate more like -
(1) User inputs will be given for "Fiscal period" through Variable.
(2) In Row all weeks lying in this period will be displayed.
(3) In Column 1, Sale for each week will be shown.
(4) In Column 2, Sale for Last two days of each week is to be displayed. (here we need to restrict Sales with last 2 Calendar days of each week.)
Point 4 is of my concern. Any suggestions will help a lot. Points must be assigned.