Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have set up two variables in the variables overview of my sheet.
Selected_City =only({<City = {$(Selected_City)}>} )
Selected_Region==only({<City={$(Selected_City)}>} Region)
This is so I can compare city progress to regional progress to global progress in a graph.
However, when my selected city is a string with a space (e.g. Hong Kong) the selected_region variable doesn't work.
Is there anyway I can get it to recognise the string?
hi,
try with double quote for that
like
Selected_Region==only({<City={"=$(Selected_City)"}>} Region)