excel 2013 create pivot table from pivot table

Click OK, to close the Value Field Settings dialog box.In this example, we’d like to see the running total down the list of dates, so OrderDate is selected as the Base Field.

Select the Base Field where you want to see the running total.From the Show Values As dropdown list, select Running Total In.In the Value Field Settings dialog box, click the Show Values As tab.In the context menu that appears, click Summarize Data By.In the pivot table, right-click one of the Sales amount cells.To change the sales field, and show a running total, follow these steps: By changing the Sales field settings, you can show a running total, instead of the normal Sum. In the screen shot below, you can see the total sales per region per month, and the Grand Total per month. Let’s take a look at an Excel pivot table based on some faked sales data. Running totals are easy with Excel pivot tables!įor example, on a worksheet you can use formulas to create a running total, but in a pivot table it’s much easier - you can quickly create running totals with a couple of mouse clicks. It’s a great way to summarize all the details, and review the overall totals.

Of course, anywhere that it makes sense to use a pivot table, I create one. They forecast sales per month by product and customer, and we use some pretty complicated formulas to sort things out. This week I’m working on a client’s sales plans for the upcoming fiscal year.

Excel 2013 create pivot table from pivot table