I have a requirement in to the daily sales report where I need to show data only for the weekdays. Bex query is based on a multiprovider and from there data gets updated on daily basis.
this is my current report output.Day Sales Cumulative Sales Avg. daily sales JAN 1 (THURS) 1000 1000 1000 JAN 2 (FRI) 1500 2500 1250 JAN 3 (SAT) 20 2520 840 JAN 4 (MON) 2000 4520 1130
what my user requires is to show only weekday data and if the data appears on saturday then it needs to added to Monday sales automatically.
In above table Jan 3 is saturday and sales was 20. Table below does not show Jan 3 at all but sale of Jan 3 of 20 is included in Jan 4. the main reason for this requirement is so that Avg. daily sales is not affected due to weekends.Day Sales Cumulative Sales Avg. daily sales JAN 1 (THURS) 1000 1000 1000 JAN 2 (FRI) 1500 2500 1250 JAN 4 (MON) 2020 4520 1507
is there anyway I can achieve this?