Previous Group Value

[craigK]

I'm trying to get the value of a previous group and not a previous record so i can get the net change of the group.

This is an hour to hour report. The data detail looks like this.

Time Queue Seconds
9:00 Billing 10
9:01 Billing 5
9:03 CS 15
10:00 Billing 20
10:15 Billing 25

On the report the grouping is first by hour, then by Queue.

9:00 Billing 15
9:00 CS 15
10:00 Billing 45

The net change i want to see is 30 seconds for billing and -15 seconds for CS.

When the report is run i should see this for the 10:00 hour:

10:00 CS 0 -15
10:00 Billing 45 30

Any help would be much appreciated.

 

[synapsevampire]

It appears that you're overcomplicating this.

If you also group by the CS/Queue field, right click the seconds field and select insert->summary->sum you'll get the sum in the new group footer.

Now right click the Queue group header and details and select hide or suppress.

-k

 

[craigK]

how do i get the column with the net change from the previous hour? the -15 and 30 seconds.