How to: Inventory Rollforward in Pivot Table

Question

How can I create a pivot table where subtotals are shown as a running total but the rows that make up the subtotals are not? In my example below, I have set the value field to "Show Values As Running Total in Months." This gets the subtotals as I want them, but the rows in between are also shown as running totals in each activity type, which I don't want. The concept is that each subtotal should show the inventory balance at the end of each month and the rows between the subtotals should show each type of change to inventory during the month (see Desired Pivot Table below).

Example Running Total Pivot Table

Desired Pivot Table

Answer 1

Hi,

I tested the subtotal in a simple PivotTable, it works:

Did the Grand Total Row is a Calculated Filed?

If yes, this is the by design behavior in PivotTable:

Hope the information is helpful.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.