After you create an Excel pivot table, you might want to know how many unique customers placed an order for each product. However, when you add the Customer field to the pivot table’s Value area, it shows the number of orders, not the number of unique customers. Unfortunately, a pivot table doesn’t have a built-in [...]

With a running total in a pivot table, you can see how amounts accumulate over a period of time, or through a range of products, as shown in the short video below. In the video, the pivot table contains monthly sales figures for several products, and we’ll create a running total by month. In the [...]