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.