Lookup function in Tableau allows you to find the values in a tableau no matter where these values are present. This will help you to return the values from different rows in a partition. Lookup function works same as total () or index () function. It will returns the value of the expression in the target row which is mentioned as a relative offset from the current row. If the target row is not determined then lookup function will return NULL value in the table.
For example below lookup function will compute sum of profit in the 3rd row of the partition.
Data set used for this example is the default superstore data set.
LOOKUP (SUM ([Profit]), FIRST () +2)
To learn more about functions used in tableau check tableau tutorial
Further, enroll for an online training course to clear the Tableau Desktop Specialist Certification exam. I would recommend this Tableau Desktop Certification Program by Intellipaat.
Back