unpivoted columns and summarization

[BiBra]

Hello

I've unpivoted two columns, to get a list of products and how many of each are available.

Now I would like to make a line chart, that summarizes the number of each product, however, 

I can only make a count of how many incidents of the product (if product is available two different stores eg. 4 in one and 2 in another, it shows 2).

Anyone know how I can do this?

[v-qiuyu-msft]

Hi @BiBra,

Please share some dummy data and clarify the expected results so we can test it. 

Best Regards,
Qiuyun Yu 

[BiBra]

Like this:

product            available

pc                          2

tv                           3

pc                          5

When I try to make the chart, I want the graph to show there are 7 pc's.

However I only get to make count of incidents. Therefore it shows 2.