Hi I am getting an ‘ORDERBY has invalid inputs’ error for the following expression.
ORDERBY(SELECT(Product_Master_File[Style / Length], AND([Product Range] = [_THISROW].[Product Range],[Treatment]=[_THISROW].[Treatment])),[Product Code])
I tried to base it of one of the samples on the expression help page but still getting an error.
Could anyone advise?