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 how-to	5	4411	September 1, 2023
How to create rank(serial number) in pivot table after grouping by columns and filter by condition Q&A how-to	5	1425	March 6, 2023
How to use a rank as column name in pivot tables Q&A calculations	4	1483	April 19, 2022
Line numbers for pivot tables Q&A charts , analysis , filters , parameters , quicksight , visuals , dashboard , dataset , calculations , Business-Intelligence-Engineer	3	106	June 25, 2024
How do I display simple row number for each row in quicksight table visual? Q&A analysis , filters , feature-request , quicksight , visuals , dataset , calculations , pivot-table , Business-Intelligence-Engineer , tables	7	181	January 13, 2025

Rank PivotTable

Related topics