Follow the below steps:
1. Create both sheets as per your question.
2. Create a calculative field to store the field value from the sheet using parameter selection.
( The list of items selected in 1 sheet make a group or make it as a field )
3. Now use the same field that you created in 1st sheet in sheet2 and drop profit field to display the profit and sales of products per region.
Hope this helps you.