Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to sort numeric values in PivotTable in two ways. Let’s get started In the caption below, we have data to work with First Method We want to sort the Sum of Total in Descending Oder in the first PivotTable Report Click on the Account Manager […]
Continue readingTag Archives: PivotTable
Distinct Count In Pivot Table: Sales Example
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to count distinctive values in Pivot Table. Let’s get started In the caption below, we have a data set of 1040 transaction records. In addition, the data set is formatted in Excel Table using CTRL + T We want to ascertain how many unique Customers purchased […]
Continue reading