Dataset according to the pivot table

[Xclipse]

Hi @Rasika_Samarakoon

Please refer the below QuickSight pivot table documentation this might be helpful for you.

Creating a pivot table - Amazon QuickSight

Super-charged pivot tables in Amazon QuickSight

Amazon QuickSight is a fast and cloud-powered business intelligence (BI) service that makes it easy to create and deliver insights to everyone in your organization without any servers or infrastructure. QuickSight dashboards can also be embedded into applications and portals to deliver insights to external stakeholders. Additionally, with Amazon QuickSight Q, end-users can simply ask questions in natural language to get machine learning (ML)-powered visual responses to their questions. Recentl…

Using pivot tables - Amazon QuickSight