How Can a Cumulative Totals Column Be Created in P6 Analytics

(Doc ID 2037085.1)

Last updated on JUNE 05, 2017

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



Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms