I am trying to calculate the rolling product revenue average of the last 4 months using set analysis in a straight table
1- Calculate the revenue of the last 4 months per product per month per year (if revenue is negative, then zero)
2-Divide the total by 4 (average per month) and then by 24 (average per workday)
3-Calculate the average revenue per weekday for each product, month and year
4- Calculate the average revenue per weekday day by day for all products
My issue is when a select one product, the table only shows the days that this product has a revenue. I would like to show all days of the month with its average revenue, even if the product doesnt have revenue in that day.