February 9, 2023, 3:53am
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.
February 9, 2023, 5:59am
This can’t be use in the rows
February 28, 2023, 9:23pm
You will need to bring this logic to SQL if you want to use it in a row
March 3, 2023, 7:56pm
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:
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!