Hi @mattraga ,
For Question 2 , you can take a look at dynamic measures : https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Interactivity-Dynamic-Dimensions-and-Measures
For Question 1 : I am not entirely sure . Would be helpful if you could put a sample data and the expected output.
an example post where sample was provided in table format ( Help with Rank function
Help with Complex Calc!
Regards,
Koushik