This may have been answered but I could no find a solution previously posted.
Below is an example of my data.
Dallas New MS
I have a map of Texas with District as the level of detail, using pie marks, and Accountability as the color. I have a SUM(Enrollment) filter, but it is filtered by the Accountability and I would like it to be the sum of the total district enrollment.
Right now it will show a range from 400 (one Dallas ISD AU School) to 3000 ( two Austin ISD AA schools). I would like the range to be 600 (total Dallas ISD enrollment) to 4000 (total Austin ISD enrollment).
They told me to create a calculated field: TOTAL(SUM(Enrollment)). Then drag the new calculation to the level of detail, right click, choose Compute using Accountability. Then add the calculated field as a filter.