I have attached an image which shows the problem and required result Excel. The measure is the count of contribution which is calculated as count(contribution). I have 2 questions:
1. I need to present it in the form of a pivot as shown in the image with the heading "Query".
2. Once the first problem is solved, I need to show row-wise sum as shown in the image with the heading "Required Result".
Please note that values highlighted in yellow are to be excluded.
