You could create a calculated field:
Top Content ID Only =
RANK(SUM(Page Views)) == 1
When entering the formula, click on the blue "Default Table Calculation" text in the upper right of the Calculated Field dialog box and select Content ID. Rank (introduced in 8.1) is better than INDEX()---with INDEX() you have to worry about sort order of the Contend ID field.
Now you can drag this to the Filter pane and select True.
Many thanks for always responding with solutions ☺
I cannot use 8.1 since our organization needs to update Tableau Server from v8 to v8.1, hence I cannot use Tableau Desktop v8. Any workaround for Rank formula?
This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and any disclosure, copying, or distribution of this message, or the taking of any action based on it, by you is strictly prohibited.
Yes, you can replace RANK(SUM(Page Views)) with INDEX()
When you click on "Default Table Calculation" select Advanced instead of Content ID. In the advanced dialog, move Content ID over the the right, Addressing window (same as compute using). On the bottom of this dialog there's a Sort section. Select Page Visits ...