Is it possible to create an aggregated summary table from a dataset, and then save this summary table as another dataset on QuickSight?
Thank you for your question. Unfortunately, currently this is a limitation while creating a dataset.
If you are looking for one-time data then you may be able to aggregate in visual and then download the CSV?
QuickSight data preparation experience does not provide a way to aggregate multiple records into one at this point in time. Many of our customers switch to custom SQL today to aggregate the data. Other options include performing data preparation using another service such as Glue Studio or Glue DataBrew.