Possibly but you would be required to provide the headers since a) cross tabs only have one header row and b) you requirement had duplicate column headings in the second row- I don’t see how the values relate so can’t comment further.
Explain clearly what the calculation actually is - where do the values for BL come from and what differentiates the two lines?
thank you, but i realized that i need a report, not a crosstab query.
thank you for the answer and sorry, i never tried a crosstab before
a report is still based off a query
Sure, but the problem is display of data more than data itself...