FILTER

Basic Overview

Description	Filter the Node with the given filter values. The result will only contain the rows of the input cube that fulfill the filter.
Signature	FILTER(Node, Level , FilterValue <, FilterOperation>)
Parameters	Node: Input node, specified using the node name in single quotes (e.g. 'Profit') Level: The level by which the input node shall be filtered FilterValue: The value by which the input node shall be filtered. This can either be a single string value or a list of strings FilterOperation: How are the values checked against the filter. The default is "EQ"(equality). Other possible values are: "NEQ"(Not equals), "GT"(greater than), "GTE"(greater than or equals), "LT"(less than) and "LTE"(less than or equals). All FilterOperations can be found on this documentation page.

Input Node

Output FILTER('Node', "Year", "2015")

Year	Product	Value
2015	M1	100
2015	M2	200

Output FILTER('Node',"Year",["2015","2016"], "NEQ")

Year	Product	Value
2017	M1	10