New to the board so if this is not the right place for this question please let me know.
I am wondering if someone could give me some advice in setting up a KPI dashboard. What I want to do is reference a benchmark value in a different worksheet to determine if the KPI is above or below the benchmark value.
Thank you all in advance.
Are you able to post a packaged workbook (twbx file) and some more details on the desired outcome?
This KB might be a good start: