My Oracle Support Banner

How Can a Cumulative Totals Column Be Created in P6 Analytics (Doc ID 2037085.1)

Last updated on SEPTEMBER 10, 2019

Applies to:

Primavera Analytics - Version and later
Information in this document applies to any platform.


How can a cumulative column be added to an analysis in P6 Analytics? For example, if showing Actual Units as a column, how can another column be added which will show a rolling sum of the Actual Units for each group.


Project Id       Calendar Year    Calendar Month    Actual Labor Units        RSUM(Actual Labor Units)

CORP00424    2010                10                       572.62                       572.62
CORP00424    2010                11                       563.57                       1136.20
CORP00424    2010                12                       313.95                       1450.16
CORP00424    2011                 1                        164.71                       1614.87
CORP00424    2011                 2                        173.71                       1788.59
CORP00424    2011                 3                        415.19                       2203.78
CORP00424    2011                 4                        327.72                       2531.50



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.