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…

Hi @MSC , It’s been awhile since we last heard from you, did you have any additional questions regarding your post? If we do not hear back within the next 3 business days, I’ll close out this topic. Thank you!

Hi @MSC , Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed. Thank you!

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 quick-sight	6	4915	December 22, 2025
How do I display simple row number for each row in quicksight table visual? Q&A analysis , filters , feature-request , quick-sight , visuals , dataset , calculations , pivot-table , Business-Intelligence-Engineer , tables	7	353	January 13, 2025
"Static" row numbering in a table visual Q&A quick-sight , calculations , Business-Intelligence-Engineer	4	56	October 16, 2025
Line numbers for pivot tables Q&A charts , analysis , filters , parameters , quick-sight , visuals , dashboard , dataset , calculations , Business-Intelligence-Engineer	3	130	June 25, 2024
How to create rank(serial number) in pivot table after grouping by columns and filter by condition Q&A quick-sight	5	1534	March 6, 2023

Rank PivotTable

Related topics