I'm new, and I'm struggling. Apologies in advance, this is probably an easy one.

I have one dataset whose rows are individual program participants and their associated demographic info. My other dataset is aggregated at the council district level, and given in percentages.

I want to compare the ethnicity percent of total per council district of the program dataset to the ethnicity percent of total of the council district dataset on the same sheet, preferably side by side. Since the datasets are at two different levels of aggregation, I can't use a quick table calculation for one half. I'm struggling with how to create a calculated field that will allow me to compare these side by side.