The FILTER function is a must-know feature for any Oracle Analytics developer to create advanced calculations in their own reports. Despite already being available when I entered the working world in 2010, it's plagued by a bug and the one line documentation is not exhaustive at all: as a result,