5 Replies Latest reply on Jun 11, 2018 9:41 AM by Shinichiro Murakami

# Top N Based on Measure without showing Dimension in View

Hello,

I've tried making this work and researching online for the past few days and I haven't been able to find the solution that I've been looking for.  Something that I am trying to do is to trend the the Summation of Revenue from our Top 10 accounts.

For example, if we have the following data:

Essentially, I want to sum the Revenue high-lighted in yellow but NOT display the list of accounts.  The complexity arises where the Top 10 accounts change by week and that we want to aggregate more than just the Top 10 - I would like to show Top 10, Next 11 - 20, Next 21 - 30, etc up to 100+.  The end goal is to show something like this via Tableau:

I've tried using FIXED and INCLUDE but neither yield what I am looking to build when I remove the accounts dimension field from the visualization.  Is there a way to do this?

Thanks!

• ###### 1. Re: Top N Based on Measure without showing Dimension in View

Hi Jeffrey,

I suggest you to solve this problem on the stage of preparing your data for tableau. Applying SQL functions rank you can then solve it very simple.

However there is a hard way =) You can visualize it. And move ranking to details.

Pls find workbook attached.

Trust this helps.

D

• ###### 2. Re: Top N Based on Measure without showing Dimension in View

Hi Jeffrey,

This type of rank calc is pretty much troublesome, but try to explain.

Sample superstore and did by every 20 customer rank.

FYI

Step 2

Thanks,

Shin

2 of 2 people found this helpful
• ###### 3. Re: Top N Based on Measure without showing Dimension in View

Hi Jeffrey,

In addition to my previous post, you can create a set from customers names that you've found.

Then you can easily visualize you figures.

Trust this helps.

D

• ###### 4. Re: Top N Based on Measure without showing Dimension in View

Thank you for this explanation, this helped me figure out what I needed to do to get this segmentation breakout and trend it.

• ###### 5. Re: Top N Based on Measure without showing Dimension in View

HI Jeffrey

You are welcome , but one thing.

Other community users will refer this as knowledge base and to avoid thew confusion, could you mark my post as Correct to show the part of correct answer description.

(Un-mark Correct==> Mark Correct right post)

Thanks,

Shin