Hi, I' m having trouble in finding the average of certain year that won't be affected by the date parameter. My data structure consist of 2 columns only, month and sales (aggregated in tableau using calculated field).
So in the picture below, the expectation is to have a column that shows the average of sales in 2022that won't change even if I change the date in the parameter
Help is greatly appreciated
6 answers
see the red tab
this is the formula I used
sum({ FIXED year([Month]) : sum([Sales])})/sum({FIXED year([Month]) :countd(datetrunc('month',[Month]))})
Thanks
Jim - Tableau Visionary
