What about creating a mapping table, so I have a mapping table something like:
LOAD * INLINE [
LOAD DISTINCT Product
ApplyMap('ProductMap',Product,"N/A") As ProductNumber_
Then could I somehow use an if statement to ensure that the if(Product=v(ProductSelection),v(ProductSelection),ProductNumber_)
I have tried this but it just deletes information if you put it as a dimension. And using it as an expression works but again, it cuts off the bottom of the product names. Is there a way to extend the area below the x-axis?