12 Replies Latest reply on Aug 15, 2018 5:47 PM by Zhouyi Zhang

# Top 10 total for Non-Aggregated sheet

Hello,

Kindly assist on how to arrive top 10 total at row level meaning unticked aggregate measures from analysis tab .

• ###### 1. Re: Top 10 total for Non-Aggregated sheet

Hi Shanmukh,

is this the way you are looking for

Kindly mark this Question as helpful/correct so that it will help others

• ###### 2. Re: Top 10 total for Non-Aggregated sheet

Nope. I have top but row level meaning I have unticked aggregate measures from analysis tab.. So now I would like to have total of top 10

• ###### 3. Re: Top 10 total for Non-Aggregated sheet

Hi Shanmukh,

Have you tried putting a rank_unique calculation as a discrete measure onto the rows shelf and then dragging this over to the filters shelf and selecting the top 10 ?

Upload a .twbx if you need an example.

Peter

• ###### 4. Re: Top 10 total for Non-Aggregated sheet

Zhouyi Zhang

Kindly assist on the below. I have attached sample file

1) sorting from Highlest to lowest

2) Top 10 Total

3) All others Total (Excluding Top 10 total)

• ###### 5. Re: Top 10 total for Non-Aggregated sheet

Hi, Shanmukh

Is it something like this? if yes, please find attached workbook

Hope this helps

ZZ

• ###### 6. Re: Top 10 total for Non-Aggregated sheet

Hello,

Zhouyi Zhang       Looks fine but unable to get result. Can you tell me steps? If you can see below \$889.89 should sum up and show as \$1,780

• ###### 7. Re: Top 10 total for Non-Aggregated sheet

Hi, Shanmukh

Where is your customer name dimension? Or what dimension in your details?

ZZ

• ###### 8. Re: Top 10 total for Non-Aggregated sheet

Zhouyi Zhang My measure is not customer name, It's actually profit and I have converted measure to dimension here.

• ###### 9. Re: Top 10 total for Non-Aggregated sheet

can you provide a sample workbook that can reflect your issue?

ZZ

• ###### 10. Re: Top 10 total for Non-Aggregated sheet

Zhouyi Zhang    Please see attached sample workbook. I have replaced customer Name with Profit(copy) which has been converted from measure to dimension. As per the data Top 10 total should be 101,745 (refer sheet 2) but we can see incorrect amount being shown. Please assist ASAP

• ###### 12. Re: Top 10 total for Non-Aggregated sheet

Hi, Shanmukh

the original top 10 is customer name based, when you change to use profit (copy), you need a new sets for top 10 as profit(copy) based.