cancel
Showing results for 
Search instead for 
Did you mean: 

Calculating Running Totals in Columns

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I was able to solve this problem by:

1) Creating 2 RKF one on DEMAND and one on SUPPLY.

2) Create a calculated key figure SUPPLY + DEMAND called Total. I made total to be cumulated check box and set the calculation along the rows in the properties tab.

3)(Then I moved the key figures structure to the rows section on BEX query

I am not sure how the cell function works but it does sound interesting. I will continue research on it to see if it will help in other situations.

Thanks,

Mike

Former Member
0 Kudos

Sorry that was calculation along the Columns. in the properties tab

Former Member
0 Kudos

please try to use cell function, please refer the link for how-to...

Former Member
0 Kudos

Not sure how to use the Cell Function.

I clicked on link and it took me somewhere else not related to cell function. It is talking about datasource customization.

I will try and search on this CELL FUNCTION Topic.

Thanks,

Mike

Former Member
Former Member
0 Kudos

I am still having problems with this.

I have not figured out a way to control the Results row that is genereated to be a running total. Without having the data also becoming a running total.

I am wanting an new running total line. And not the standard Results row unless I can make it a running total and it leaves the data alone.

Material|Type| Nov-05| Dec-05| Jan-06| Feb-06|....<Dynamic>

PART1| DEMAND| -42 EA| -46 EA| -33 EA| -3 EA|....<Dynamic>

PART1| SUPPLY| 58 EA| 0 EA| 0 EA| 49 EA|....<Dynamic>

Standard Results Row:

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

I want this. Running total of the standard results.

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

I will look more on this next week.

Thanks.