I have a report that consists of two queries unioned together. The first query gets all the Level_GL_Codes with equal to PM and the second gets all the Level_GL_Codes equal to PS. I want to add a '% Sold' column between AmountNote and OriginationDate for each PS group. So in the image the % Sold for Southwest would be 4085820.25 / 8988634.37. I am not sure how I would do this. Do I need to create a field in the queries pre join? Any tips would be appreciated.