How to include Quarter1- Quarter2 to the expression =sum(if(R_View='G','A','B'))

[Vamsy1991]

How to include Quarter1- Quarter2 in below expression(need to be include Quarter 1-Quarter 2) =sum(if(R_View='G','A','B'))     

T =Quarter 1,Quarter 2

R_View=G,N

A - Sales

B- Profit

[Kushal_Chawda]

@Vamsy1991  try something like below

Pick(match(R_View,'G')+1,

Sum({<Quarter ={'Q1','Q2'}>}Profit),

Sum({<Quarter ={'Q1','Q2'}>}Sales))

[Vamsy1991]

Thanks for your reply,When i tried throwing the error.

Below is the requirement Q1- Q2

[Kushal_Chawda]

@Vamsy1991  What is the error? Where is the requirement?

[Vamsy1991]

Showing error in expression and Q1-Q2 is the requirement