plot different measures (y-axis) against different quarters (x-axis) in a single line in Line Chart

lbendlin  I can't post actual data but created similar sample data in excel.

here is the google drive link to access excel data: 

https://docs.google.com/spreadsheets/d/1Cr84ZsLw4qhOKmNJ48XXHONYksq7X_7S/edit?usp=sharing&ouid=102328248117579165613&rtpof=true&sd=true

To calculate Average sales amount for 4th Quarter 2023, use sheet  2023Q4 :

1. Filter Completion Date between 2023/10/01 to 2023/12/31

2. Transaction Type = Completed

3. Demand Status = Fulfilled

( as per sample data, Average sales amount for 2023Q4 = $65.29 )

To calculate Average sales amount for 1st Quarter 2024, use sheet  2024Q1 :

1. Filter Completion Date between 2024/01/01 to 2024/03/31

2. Transaction Type = Completed

3. Demand Status = Fulfilled

( Average sales amount for 2024Q1 = $62.94 )

To calculate Average sales amount for 2nd Quarter 2024, use sheet  2024Q2 :

1. Filter Completion Date between 2024/04/01 to 2024/06/30

2. Transaction Type = Completed

3. Demand Status = Fulfilled

( Average sales amount for 2024Q2 = $68.36 )

Since 3rd Quarter 2024 is still running, it will have different filters to calculate "Projected average of sales amount:

1. Filter Completion Date between 2024/07/01 to 2024/09/30

2. It will consider ALL transaction Type

3. It will consider ALL Demand Status

(Projected average of sales amount for 2024Q3: $73.92)

Expected out for 1st Line Chart should be similar to as per below image:

For 2nd Line chart, we can drag Category column and drop on this line chart which will give 4 different lines in the same Line chart representing each category and providing Average sales amount against Quarter.

Let me know if any further info is needed.