# Using LOD expressions & LOOKUP function to compute YoY/QoQ/WoW/MoM/DoD Profits

Requirement: I’ve created below bar chart showing States Vs SUM(Profits) for India. Requirement is to display Up/Down arrow based upon SUM(Profit) by State, YEAR(Order Date) on YoY.

For example, If I select the Year=2016, then difference between SUM(Profits) should be calculated by Year for that particular state only.

Sum(Profits) in…

# Computing grand totals of Discrete Measures using RUNNING SUM and LOOKUP filter in Tableau

Task: Create a detail report in Tableau and keep multiple discrete measures between 2 discrete dimensions.

As we all know, continuous measures can’t be kept between 2 discrete fields, thus it is required to make continuous measures as discrete.

After doing this, now if we want to display Grand Totals

# Calculate Delta,% Increase with Up/Down Arrows on YoY,QoQ,MoM,DoD using Lookup function in Tableau

Why Lookup? What is use of this function?

LOOKUP function is used to look up and down a partition of rows and return a values in that field by specifying an offset. This can be used Lookup previous or next value within resp. partition to compute required calculation.

LOOKUP is… ## Ajinkya Abhyankar

BI and Data Enthusiastic - Tableau and Teradata ETL Developer