Thanks for your Response.
I want Top N And Bottom N both on the same worksheet.
if index()<=[TOP/Bottom N] then 'Top N'
elseif index()>=size() - [TOP/Bottom N] then 'Bottom N'
Drag dimension into row.
drag this calc into filter and select topN and bottom n.
Compute using your dim.
Sort the values too.
You can get both in single sheet.
Hi @RAGHAV MEHTA,
Tableau Public Link:
Please mark this as helped if you got the answer.