Let me give you some background.

My question is very simple. I am looking for a method to store the pivot table generated by Quicksight and plot its data by a line curve. It is the main question.

I did search over the internet, and could not find the solution. There were comments by people that Quicksight is weak working with pivots as the source of data. So, I generated the pivot inside Excel, rotated it, used it as the data, and plotted it using a Line curve. The line curve I have uploaded is plotted by Quicksight and I want this. BUT, I do not want Excel to do it.

The only solution that came to my mind was to use SQL to replicate what Excel did, but I could not rotate the results of the goup-by in SQL.

Here is the pivot:

I have added required table and plot in Pivot over pivot - #2 by Franc3sc0