I have the following crosstab query in Access. Is there a way to calculate the percentages for each Order Type by Fiscal Year (i.e., 2018, 2019, etc.)?
Example: Order Type "18" for Fiscal Year 2018 = 21,973.55. This would be 23.2% of 2018 Total or (21,973.55/94,699.85).

Thanks