Skip to Content
0
Former Member
May 01, 2014 at 06:26 AM

WEBI dates

529 Views

Hi All,

I'm using BEX query on WEBI and have the Date and Sale Order as fields.

I want to show count of sales order for each day. but the tricky part is based on the date (01.05.2014) i want to determine whether its Monday, Tuesday etc. and based on the date i want to determine if its this week or last week. Basically my output should be as per below.

Day M T W TH F

SO this week 6 9 2 16 3

SO last week 15 12 6 7 9

Is this possible in WEBI. Any help is highly appreciated.

Regards,

DTD