How can I get the total price based on "type"?

[_dave]

Let’s say I have two columns with price and type, how can I get the total for “M” and “P”?
Total Price.ods (13.9 KB)

[karolus]

hallo
see attached file…
Total_Price_pivottable.ods (12.3 KB)

[_dave]

How was the pivot table set up?

[karolus]

Hallo
→Data→Pivottable→create…

[EarnestAl]

Right click the pivot table and select Properties to see arrangement of fields. Field Type could instead go in the Columns for a slightly different appearance.
Help button is available from Properties dialogue

[PKG]

SUMIF()