tableau - LOD (Level Of Detail) where Year = -

trying write calculation in tableau allows me fix level of detail on category year equal designated date.

imagine looks like

{fixed [report category] : avg(dollars paid)} year = 2015

you have couple of options.

1) add year dimension lod calculation , add year filter card , set '2015'. calculation this:

since have no year, need create calculated field reference it.

"year" : year(apcd paid accnts date)

{ fixed [report category], [year]: avg(dollars paid) }

2) can restrict aggregation specific year in calculation, so:

{ fixed [report category]: avg(if year([apcd paid accnts date]) = 2015 dollars paid end) }

-- edit --

updated above because stated using date not number of year.