Hi. I want to create a stacked bar chart with rolling two month average. The dimensions are Product and Month , Measure being Sales. But for some months there is no data available for certain country (Country is a filter ). So if the Data for June is missing, then the rolling avg should take the data of July and May to calculate July Average. Similarly if the data for two months are missing, it should take the data of last available month. Is there any method to implement this dynamically ?
