I feel like I'm overlooking something that should be obvious, but I'm unable to calculate % of total for a column prior to my 'Rank <= 25' filter. I only want to see top 25 of my rank column, but I want to see % of total for everything prior to filtering to the top 25. I know I can create a separate query that rolls up to the highest level and join it in, but that seem unnecessary for what seems like it should be very simple. The % of total column works perfect when I make the top 25 filter required or disabled, so I got that going for me at least. Any suggestions on what I can do to make this work without creating another query?
I may have posted this question prematurely. I appear to have arrived at the solution by changing the detail aggregation on my '% of total' column from 'Calculated' to 'Total'.