Skip to Content
0
Former Member
Mar 25, 2015 at 12:43 PM

Hide weekend figures in daily sales report

20 Views

Hi Experts,

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?

regards,

BIapp