Non-hierarchical Pivot Tables

Hi,

I am trying to make a Pivot table where the rows are based on different columns. However, there is no hierarchical connection between those columns. I want the pivot to be displayed as a table, so without any hierarchy between the columns.

For example, we have a list of companies who make products, say cars, toys and soap. However, some companies produce multiple products (Comp A produces cars and soap). From each company we also have their net value.

Company Car Toys Soap Net Value
A Yes Yes $10
B Yes $50
C Yes Yes $20
D Yes $40


Now, I want to make a pivot table giving the summed up net value of companies per product:

Net Value
Car $30
Toys $70
Soap $50


So there is no hierarchy between the Car, Toys and Soap. We do have a lot of metadata (such as country, region etc) which is why we want to use pivot tables instead of just excel formulas.

Hopefully someone can help!
Lennart