I have a dropdown 'Bank Name' and a field for grouping of banks called 'Peer Group' (values are 'Assets < 100 million', 'Assets between 100 and 300 million' etc.). I also have a measure 'Net Income' by bank.
I want the user to select a bank from the dropdown and then show the 'Net Income' for the selected bank. Side-by-side, I also want to show the average net income for the 'Peer Group' that the selected bank belongs to. How can I do this? What will be the 'Set expression' to do this? See example below.