I have a requirement in Query that is:
For a particular Sales Order No and Sales Order Item and InfoObject "Y" =1,
if InfOObject "X" = AB, add KF1,
else if InfoObject "Z" = AC, subtract KF1
Note: InfoObject Y, X & Z are characteristics not KeyFigures
How can this be achieved in Query Designer?
Thanks in advance.