AnsweredAssumed Answered

Portal Running Total for a specific record

Question asked by rasen on Jan 29, 2018
Latest reply on Jan 30, 2018 by rasen

I have two Tables:

Project Master Table with:

pk_ID

Project Expert ID

Contract Manmonth

 

Remuneration Table with:

pk_remuID

fk_ID

Project Expert ID

Billing period [date field]

Invoiced Manmonth [eg: 0.9 months for billing period ending 31 Jan 2018]

 

Problem:

I have invoiced manmonth data for 550 Project Expert ID for last 45 months. I am able to create Portal in Remuneration Table TOC with all the data in. However, I want to show running total for each Specific Record ( i.e. each Project Expert ID) in the portal. I succeded to get the Summary Field with sorted Project Expert ID but that is not what I want!

 

I want to keep the Project Expert ID in the same order Billing period after Billing Period and then have running total for each Project Specific ID. For example:

 

Project Expert ID          Billing Period          Invoiced Manmonth               Running Total [what I want to show]

A                                   Nov 2017               0.4                                             0.4

B                                   Nov 2017               0.5                                             0.5         

C                                   Nov 2017               0.6                                             0.6

A                                   Dec 2017               0.4                                             0.8

B                                   Dec 2017               0.3                                             0.8

C                                   Dec 2017               0.7                                             1.3

A                                   Jan 2018               0.5                                              1.3  

B                                   Jan 2018               0.2                                               1.0  

C                                   Jan 2018               0.1                                                1.4

 

HOW CAN I GO ABOUT RESOLVING ABOVE CASE!

 

PLEASE HELP

Outcomes