Then add the Criteria, which is Mango, because we want to find the sum of mangoes sold ... How to create a Pivot Table and Pivot Chart in Excel.