Skip to Content
author's profile photo Former Member
Former Member

Calculating Running Totals in Columns

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2006 at 07:05 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 02:16 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.