Skip to Content
0
Former Member
Sep 20, 2006 at 06:54 PM

Calculating Running Totals in Columns

95 Views

I am trying to calculate running totals in Dynamic columns

I have data that is monthly and want to create a running total in the columns.

Data Format in:

Material|Type|Month|Qty

Query Report Ex:

Material|Type| Nov-05| Dec-05| Jan-06| Feb-06

PART1| DEMAND| -42 EA| -46 EA| -33 EA| -3 EA

PART1| SUPPLY| 58 EA| 0 EA| 0 EA| 49 EA

Result| | 16 EA| -46 EA| -33 EA| 46 EA

I would like running total taken from totals from previous columns + current column total are dynamic:

Result| | 16 EA| -30 EA| -63 EA| -17 EA

.

.continues for more parts

.

PART2

Thanks,

Mike Walker

FMC Technologies Inc.