Date order for cumulative total

Dan Wilson_yo7x7a

Hi there, I am trying to set up a cumulative total for my pivot table (I am on version 6.14 and don't have the cumulative total option in pivot table).

I am using Jira data on the resolved column, and have set it up as follows:

I can get the date to pass through correctly for Table Filter and Pivot Table as below:

But when I apply the Table Transformer, the date format seems to be defaulting back to string, and applies the cumulative calculation that way as well:

Could someone help me with the correct code to be using?

Katerina Kovriga {Stiltsoft}

Hi @Dan Wilson ,

You may look how to do the cumulative count with the Table Transformer here.

Not sure what you mean that the date turns back to string (you don't necessarily need to have real dates in the first column - you may have "New day 1", "New day 2", etc. and the cumulative count for the second column will be working fine).

I've checked the behavior for the current version of the app that is 8.8.0. Strongly recommend to update. Besides lacking different features (for example, the cumulative count in the Pivot Table macro mentioned above), you don't have our new macros - check the Table Spreadsheet macro.