We like to see your TWBX workbook to give you a good answer - I can see from the screen shot your file is wide (like excel) vs tall (Like Tableau or access files)
That would make doing what you want complicated
suggest you look at pivoting the data Pivot Data from Columns to Rows
and then using table calculations to get you where you want to be -
If you attach a TWBX workbook with the data we can be more specific with a solution
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.