Lookup() in Tableau | How to get Second max of Sales in Tableau

Purpose: LOOKUP() is used in Tableau for accessing the value of a specified field from a different row within the data partition. It enables you to retrieve values from previous or subsequent rows.
Syntax: The basic syntax of the LOOKUP() function is LOOKUP(expression, [offset]). The expression is the field you want to look up, and the optional offset specifies the number of rows to look up. A positive offset looks forward, and a negative offset looks backward.
Default Offset: If the offset is not specified, LOOKUP() defaults to an offset of -1, meaning it looks up the value from the previous row.
Data Partition: The behavior of LOOKUP() depends on the data partition defined in the view. If there's no partition specified, it considers the entire table. Partitions can be set using table calculations or specific fields.
Use Cases: LOOKUP() is often used for calculating running totals, finding the difference between consecutive values, or comparing the current value with a value from a different row.
Handling Null Values: When using LOOKUP(), be cautious about null values. If the looked-up value is null or the offset goes beyond the available rows, it may result in unexpected behavior. You can use the ZN() function to handle nulls.
Aggregation: LOOKUP() can be used with aggregated fields. For example, you can calculate the running sum of aggregated values using the LOOKUP(SUM([Field]), -1) pattern.
Filtering Impact: Keep in mind that filters applied to the view can affect the results of LOOKUP() calculations. Ensure that your filters align with the desired context for the lookup.
Performance Considerations: While LOOKUP() is a powerful tool, excessive use or misuse can impact performance. Use it judiciously, especially with large datasets.
Advanced Usage: LOOKUP() can be combined with other functions and conditions for more advanced calculations. Experiment with different scenarios to achieve the desired outcome in your Tableau analysis.

[@alexavila8512]

Gone through your most of the videos and are interesting

[@Naveenchandra18]

Excellent 👌

[@aaronbergman7223]

Yeah

[@alexavila8512]

This is good explanation 👍

[@Mashumaehu]

Good job

[@aaronbergman7223]

Yeah

[@Emmanuel-cm3uc]

Nice explanation

[@TableauExperts]

Thank you

[@aaronbergman7223]

Excellent

[@TableauExperts]

Thank you

[@Swethasweru]

Thank you

[@Sureshmanchukoti12]

It’s a trick to get use of Table calculations and explained very well

[@TableauExperts]

Thank you

[@Sandy-ef5pp]

Tq

[@Gangusind]

This is excellent

[@SolaRabi]

This formula is not for the max value or min or 2nd max, it will show the order number , for example it will show the 2nd number value in the row rather than 2nd max value, to get the 2nd max value you need to sort it in the descending first , then this formula will give you the 2nd highest value

[@Rohit-fc6yw]

Is there any way to get this done

[@Josephtext]

Can you pass parameters for the lookup function

[@aaronbergman7223]

😂

[@Nana_E-yt2zs]

😂😂

[@supersayan9888]

Is it me or is the voice so unnatural?

[@TableauExperts]

😂

[@adambellavance6581]

😀😀

[@Gangusind]

What

[@Sanoondoor]

Thank you

[@TableauExperts]

Thank you