Adding Up within a Variable

[DoubleStew]

I have a report which returns the hours that a person has worked in the last 6 months. Not all of the employees will have worked every month in that 6 month period.

I want to display a summary report which shows the total hours they have worked in the last 6 months AND a total of the last 3 month's hours that they have worked. e.g.

In the last 6 months Emp A has worked 7, 9, 0, 4, 4, 8
In the last 6 months Emp B has worked 6, 7, 2, 4, 3, 2

So, I want my report to show
Total Hrs Last 3 Months Worked
Emp A 32 20
Emp B 24 15
Any ideas on how to achieve this? It's hurting my brain.

 

[skrandel]

You need to bring back something related to the month number. Preferably a relative month number. Then you can build this in Reporter using the Where operator.

You should download my presentation from this year's user conference. It was called Empower Users through Smart Universe Design. It has examples of something very similar to what you want.

Can you possibly do something with a CASE statement in your universe to do the bucketing?

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com