Hi,
I'm trying to calculate the percentage that each calculated line item in a query represents of the total of all calculated items and I cannot figure out how to calculate the denominator without error. If it helps, here is how I'm calculating the individual line items:
SELECT DISTINCTROW [Sector Distribution].Category, Sum([Sector Distribution].WeightedExposure) AS SumOfWeightedExposure
FROM [Sector Distribution], [Sector Denominator]
GROUP BY [Sector Distribution].Category;
I now simply wish to sum all of the "WeightedExposure" and then divide each WeightedExposure by the total of all WeightedExposure. I would think this would be relatively easy to do but I'm a beginner who started working with Access less than two weeks ago. Any help would be greatly appreciated. Thank you.