Excel for Mac 2016 - Error in Pivot Table using Running Total

Question

I have Excel 2016 for Mac through Office 365 and found a weird issue that I don't know how to fix.  It looks like the Running Total in that is a selection as part of a Pivot Table doesn't seem to work properly.

Here is a Pivot Table that I have where LTR is simply Feature Revenue/Num Customers as a Calculated Field.  The values here are calculated correctly.

When I take the LTR calculated field and then try to do a Running Total in

I get very weird data as a result...

The Running Total in LTR over TOB for 2017 shows values for Column H and onward and it seems to be doubling the last value shown - it's very strange.

Anyone seen this or know how to fix.

I gave the spreadsheet to someone using a PC and the calculations are correct.

Thanks!

Answer 1

Hi Dan,

Is there any update?

Regards,

Jiaxing

Answer 2

Hi Dan,

Sorry for the late response.

We have received your Excel document and the repro video, and found the content in the Excel document is different from that in your video.

To further clarify the scenario, please provide another video with your steps from the beginning.

Regards,

Jiaxing

Answer 3

Hi Dan,

To clarify the exact scenario, please share with us the information below:

1. The problematic Excel document.
2. Capture a video of your detailed steps to reproduce the issue.
3. The version of your Excel for Mac (Click Excel > About Excel) and Mac OS.

To protect your privacy, I have sent you a private message (PM), which can be accessed via the link below:

https://answers.microsoft.com/en-us/privatemessages/list

Regards,

Jiaxing