I have a Column as QTR for quarter which includes Q1, Q2,Q3,Q4 also i have a particular column which has entry as Net Revenues, Net Operating Income, Net Cash Flow where these all are measures created. and i created one filter which Has YOY, QOQ, I want NOW I WANT THE MEASURE WHICH GIVES me if option = YOY , and if type=Net Cash Flow then show me the value of measure net cash flow of the previous year as year selected in the filter if type=Net Operating Income then show me the value of measure Net Operating income of the previous year as year selected in the filter if type=Net Income then show me the value of measure Net Income of the previous year as year selected in the filter also if option = QOQ , and if type=Net Cash Flow then show me the value of measure net cash flow of the previous quarter as year and quarter selected in the filter if type=Net Operating Income then show me the value of measure Net Operating income of the the previous quarter as year and quarter selected in the filter if type=Net Income then show me the value of measure Net Income of the previous quarter as year and quarter selected in the filter
i used this measure but it is giving error in expression