7 Replies Latest reply on Mar 29, 2018 12:54 PM by Andrew Bickert

# How to get the maximum value from another column in the tableau report

Hi,

I have a scenario where I have to display the maximum value in another column. I have to populate the middle column(Maximum Value) based on Values column. Can someone post some suggestions/thoughts on how to achieve this?

Prashanthi

• ###### 2. Re: How to get the maximum value from another column in the tableau report

Hi Prashanthi,

You can use a level of detail expression to do this. Create a calculation with the following formula:

{ INCLUDE [Report]:MAX([Values]) }

This will give the Max Value for every unique Report

Kind Regards,

Andrew

• ###### 3. Re: How to get the maximum value from another column in the tableau report

Thanks so much Andrew. This worked.

• ###### 4. Re: How to get the maximum value from another column in the tableau report

Awesome! Can you mark the response as correct so it closes the thread!

Andrew

• ###### 5. Re: How to get the maximum value from another column in the tableau report

what is the difference betweenn INCLUDE and FIXED?

• ###### 6. Re: How to get the maximum value from another column in the tableau report

This is a very broad description for level of detail but essentially the LOD expressions apply to the dimensions that are currently on the view and are a way to manipulate or calculate off of them.

Here is a good link that helps identify the difference:

Andrew

• ###### 7. Re: How to get the maximum value from another column in the tableau report

Hi Prashanthi,

If you could mark the reply that was the correct response instead of your own as a response, it helps when other people are looking at threads they can easily find the correct answer as it goes to the top of the screen.

Good Luck Tableauing!

Andrew

------

Hi Prashanthi,

You can use a level of detail expression to do this. Create a calculation with the following formula:

{ INCLUDE [Report]:MAX([Values]) }

This will give the Max Value for every unique Report

Kind Regards,

Andrew