I want to create a variable containing the name of the product ranked 1, and create 9 others, in order to use the variable in a graph.
However, when I add the above formula to a text box, it only returns a null value.
Does anyone know why? I'm suspecting it is because there are more than one product that is ranked number 1, however, I am not too sure which rank mode to use to negate this. Please can someone possibly assist?