@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 | 5 | 114 | May 25, 2024 | |
| How to achieve this layout in Quick Sight | 7 | 120 | June 13, 2025 | |
| Create a Pivot Chart | 3 | 121 | June 14, 2024 | |
| Visualization from pivot table | 2 | 45 | September 6, 2024 | |
| Can we pivot data in Quick Sight? | 1 | 1522 | March 23, 2022 |