First, my favorite ETL and reporting tool, Alteryx. Nothing seems to come close. When delivering a report in Excel, Power Query is useful but can get you so far if the data is big, SQL turns into 100s of lines of code, and 10’s of steps needed in the power query process. Alteryx makes flow transparent especially if loops using macros are needed.
Detail column has 4 points of data in it. Text to Columns is first step to get 4 new columns the the Transform tool turns Vehicle Spaces and Bicycle Spaces in column headers.
Summarize both spaces totals and subtract one from another in the Formula tool.
