How to create rank(serial number) in pivot table after grouping by columns and filter by condition

Here I want a pivot table that grouping by two columns and after user choosing the years and filters, I need a serial number of rows.

How can I achieve that? I already tried dense_rank calculated fields, but it won’t allow me to put it as another grouping column.

Hi,

may this help you

regards,
Naveed Ali

This can’t be use in the rows

You will need to bring this logic to SQL if you want to use it in a row

1 Like

Hi @Lintao,
Can you modify your calculated field and add PRE_AGG to it and then try? My field is:
denseRank( [Subregion ASC], [Region], PRE_AGG). Results below:

1 Like

Hi @Lintao

Hi, Did Max’s or Asem’s solutions work for you? I am marking Asem’s reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!

1 Like