For more information, please refer to this announcement explaining best practices for getting answers to questions.
Advanced SQL filter
Summary
return max value from sql filterContent
Hello,
I built a Table view to display some data and some of that comes from the Matrix Manager folder in the Workforce Performance - Performance Rating Real Time subject area. I want to include several levels of managers from the matrix, but only return a single row for each employee (there are several names in the Manager name fields). I found that the Top Manager can be used to anchor the rest of the levels, but I need to retrieve only the true top manager.
I found that the max value in the Top Manager Level corresponds with the true Top Manger name and I want to filter on the Max Top Manager Level for each employee so the query only returns that one Top Manager