1 of 1 people found this helpful
Parameter will not add updated date automatically. We can manually add new dates in parameter.
Please create parameter will all option and not list.
Thank You for replying.. I had tried this option however the filter displayed is in calendar format and the users might get confused as the data is at monthly level.
Can you please attach the workbook with the changes if possible please..I am not sure if I can use the range and still calculate variances for each of the month
I shall try it though.. Can you post an example pls.
Thank you so much for repying
Refer the below screenshot and attached package.
If you are able to get the variance without filter than you should also be able to get the variance with date range filter(select "To" and "From" date as start and End of the month so that the variance is calculated through-out for boundary months) since MyDate field will group the aggregation on MonthYear.
Hope this Helps!!
Slide 7-DG.twbx 21.8 KB