Skip to Content
0
Former Member
Apr 08, 2014 at 04:43 PM

Getting Life to Date values

39 Views

Hi there folks,

I am trying to do a BEx query and the requirement is to show life to date values for orders along with the respective fiscal period values. What is the best way to achieve this so that only records for selected fiscal period are displayed but along with Life to date values?

Here is a rough layout of the query:

Order# Fiscal period $costs $costs (life-to-date)

10001111 001.2012 5,000 50,000

10001111 002.2012 5,000 50,000

10001112 001.2012 6,000 30,000

10001112 002.2012 7,000 30,000

10001112 003.2012 7,000 30,000

10001113 003.2012 5,000 10,000

Appreciate your comments regards how to handle this.

Thanks!