Below is a summary table by census topic and sub-topic vs. by geographic area. I want to show instead of the sum, the percentage.
Select Analysis from the menu. In the drop down menu, select Create Calculated Field…. Create “Percent of Total” with the following formula.
Drop the “Percent of Total” from Measures to the Text icon in Marks.
