@Mohammed_Farhan
Agreed. You would have to either use custom SQL in Quick Sight or Glue DataBrew as suggested in this post:
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Pivot over pivot | 4 | 126 | May 25, 2024 | |
| How to achieve this layout in Quick Sight | 6 | 136 | June 13, 2025 | |
| Create a Pivot Chart | 3 | 132 | June 14, 2024 | |
| Visualization from pivot table | 2 | 46 | September 6, 2024 | |
| Can we pivot data in Quick Sight? | 1 | 1526 | March 23, 2022 |