Challenge_6

How do calculate the sales over the last 30 days for one product and 45 days for remaining products dynamically from selected date?

Example:

Using Superstore data set,

for  Sub categories (Phones, Paper, Furnishings) we need to calculate total sales for last 30 days 

and for remaining Sub-Categories we need to calculate total sales for last 45 days  from selected date.

In the below, I changed the selection date to 2017-08-02 then the sales for Phones, Paper, Furnishings it showing last 30 days sales and for remaining products its showing last 45 days sales.

Please Subscribe to get new Notifications

If you crack the challenge send me the workbook or logic to this mail id: skrafi449@gmail.com