Skip to Content
0
Former Member
Apr 22, 2014 at 09:14 PM

Previous 7 days average

20 Views

Hello Guru's

I'm learning Bex. Struck here and need little push, Please help.

Our requirement is to display 2 KF's.

1. Last 30 days Sales Volume and

2. Last 7 day Average of Sales Volume for 30 day's.

Last 30 day Sales is directly from KF and I'm restricting date's in Query to get 30 dates.

I have no clue, how to get Last 7 day Average for 30 days - Any help is highly appreciated.

Thank You

Karthik