5 above and 5 below a selected rank with RANKX

Good morning, jbressan! Your solutions for selecting the City based on the Census Rank worked perfectly! This has really helped me. Would you be able to help me make the Census rank select when the City is selected? I want to automate this as much as I can. I will be using this for various cities, and when a City is selected, if I can automatically have the census rank selected. Otherwise, I will have to have the slicer for the Census rank on the screen and manually select the rank. I really appreciate your help on this! Thank you!

Hi @tjohnson

Generally, once a problem is marked as “Solved” it’s best to start a new thread for additional questions, since many of us who scan the forum regularly for questions to solve focus our attention on those posts currently marked as unsolved.

If you wouldn’t mind initiating a new topic on this question.

Ok. I will later today. Thanks