Created 'membership_summary' view and updated dashboard to use the view.