This may have been answered but I could no find a solution previously posted.
Below is an example of my data.
|Austin ISD||Austin HS||AA||2500|
|Austin ISD||Austin MS||AU||1000|
|Austin ISD||Austin El||AA||500|
|Dallas ISD||Dallas MS||AA||200|
|Dallas ISD||Dallas New MS||AU||400|
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).
Thanks for any help.
I got some help from the Tableu staff.
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.