How do I display simple row number for each row in quicksight pivot table visual?

[sagmukhe]

Hello @HenryQS - Welcome to the Community! Thanks for posting your query. There’s no out of the box way to do this in Quick Sight. I believe, when you say that you would like to add row number in pivot table as rows that means it has to be a dimension and can’t have custom aggregate levels. However, please take a look at the following link and see if this helps! Thankyou!

Adding a Sequence Number to Table Visualizations

Hi, To add row numbers, you can leverage a combination of concat and denseRank functions. Include the String and output of denseRank in the concat calculation. The concat take only string inputs, so you may want to convert the rank output (originally integer) to string using toString(input ) function. Hope that helps. concat(expression, expression, expression… ) denseRank([sort attribute ASC/DESC, …], [partition by attribute, …], calculation level )