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:
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!