6 Replies Latest reply on Jan 10, 2017 1:21 PM by Matthew Risley

# Display only highest percentage by store

I have a report that has multiple Managers and Stores that display 80% or higher.  My challenge is that I only want to display the max percentage per store regardless of the "Period".  For this example, Store A has two entries => 80%.  I only want to see a result that shows:

A     Week     90%

How can I make this happen?

• ###### 1. Re: Display only highest percentage by store

Mark,

The approach will depend on how your data and aggregations are structured. Please attach a packaged workbook that illustrates your current state, and the community can provide more specific guidance. Thanks.

• ###### 2. Re: Display only highest percentage by store

I'm thinking that a LOD expression will work here?

{EXCLUDE [Period] : MAX([Percentage]) }

1 of 1 people found this helpful
• ###### 3. Re: Display only highest percentage by store

Hi Matthew,

That get me where I needed to show the MAX percentage and EXCLUDE the one I did not need.  I also created a calculated field called MAX(Period) to show what Period goes with the max percentage!  Thank you so much!!

Mark

• ###### 4. Re: Display only highest percentage by store

It was my pleasure to help.

LOD calcs can be confusing and even I still get confused with them. Here is a good resource if you'd like to understand the "why" behind the solution: Understanding Level of Detail (LOD) Expressions | Tableau Software

Happy Tableau-ing!

• ###### 5. Re: Display only highest percentage by store

...now my challenge is whenever a Managers Store OR Region is >=80%, both the Store AND the Region is appearing on the results under the Store column.  If the Store AND the Region is the same percentage (90% for this example) then I need to exclude the Store record and keep the Region.  I know it may not make sense as to why but I need to make this happen for the Recipient of the data.

Any direction would be great...

Thanks,

Mark

• ###### 6. Re: Display only highest percentage by store

This part will be hard without seeing the data...

Please attach a workbook or data (i only have version 9.3)

Also, is this an entirely new question or will you be working off the solution I gave? If it is a new question, I'd suggest splitting off with "branch" on the forums so others will chime in as well:

My guess for this scenario would be a string of if/else statements and possibly more LOD calcs.