How to Show Goals by Person and Product

[rivalenc]

I'm trying to find a way to show goals per person, per product.

Here's a sample of what I'm working with:

Name	Goal 100	Goal 101	Goal 102
John	200000	10000	5000
Bill	200000	10000	5000
Mandy	200000	10000	5000
Jennifer	200000	10000	5000

From the table above, we can determine the overall goal for each product is:

Product	Goal
100	800000
101	40000
102	20000

Each person is provided an overall goal that is then broken up by product. How do I show the overall goal for a product with a given set of people that can be filtered by whatever criteria?

I want to show progress towards the goal for each product, as well as the total sales of the person towards the total of their goal?

I'm thinking this is probably something pretty simple and I'm just overlooking it. 

Thanks! 

[ryan_mayu · Accepted solution]

@rivalenc 

pls select the first column and unpivot other columns, then the value will be in one column . That will be eaiser for you to sum the data.