Hi everyone, I have a pivot table with several value columns in Quicksight. The end users can sort the pivot per value column as desired. But since there are about 500 rows, I would like to make a kind of rank column that only shows the row number. (a real rank is not possible, because as I said it…

Hi @MSC Please refer to the following and see if that gets you the results you want. [image] How to add a new column in (Row ID) which is sequentially increasing Question & Answer Hi @Biswajit_1993 - See the solution here and how to generate a row number using the Rank…

Rank PivotTable

Q&A

Giridhar.Prabhu January 24, 2025, 1:35pm 2

Hi @MSC

Please refer to the following and see if that gets you the results you want.

Regards,
Giri

Topic		Replies	Views
How do I display simple row number for each row in quicksight pivot table visual? Q&A	6	4699	December 22, 2025
How do I display simple row number for each row in quicksight table visual? Q&A analysis , filters , feature-request , visuals , dataset , calculations , pivot-table , Business-Intelligence-Engineer , tables	7	252	January 13, 2025
"Static" row numbering in a table visual Q&A calculations , Business-Intelligence-Engineer	4	37	October 16, 2025
Line numbers for pivot tables Q&A charts , analysis , filters , parameters , visuals , dashboard , dataset , calculations , Business-Intelligence-Engineer	3	114	June 25, 2024
How to create rank(serial number) in pivot table after grouping by columns and filter by condition Q&A	5	1489	March 6, 2023

Rank PivotTable

Related topics