1) What is the equivalent method to accomplish " sum sales across type" in Power BI?

[Ron_ald]

!) What is the equivelent method to accomplish " sum sales across type" in Power BI as presented in the pivot table example below?

Source Table

Commodity	Sales	Date	Type
Shoes	500	1/30/2020	men
Shoes	600	1/30/2020	women
Pants	800	2/28/2020	men
Pants	600	2/28/2020	women
total	2,500

Result

[TomMartens · Accepted solution]

Hey @Ron_ald ,

inside Power BI Desktop use the Matrix visual.

Drag the commodity column to the rows well, the type column to the columns well.

Drag the Sales column to the values well.

Here is a screenshot, of the Matrix visual, with colors on rows, countries on columns and quantity as value:

Hopefully, this will provide what you are looking for.

Regards,
Tom

[Ron_ald]

That worked.  Thanks!!

[lbendlin]

You can use a matrix visual to get the equivalent of an Excel Pivot table.