Running Total

Michael Hyder, MBA, CPIM
edited February 2023 in Platform
How can I calculate a running total in Board? I want to see how our yearly sales are pacing against our yearly forecast.

Jan    10     10
Feb     10     20
march 30     50
april      50    100
may     5       105

------------------------------
Michael Hyder, MBA, CPIM
Global VEG Control Tower Process Lead
Bayer Crop Science LP
United States
------------------------------

Accepted Answer

  • Navan Mehra
    Navan Mehra Employee
    Third Anniversary 10 Comments 5 Up Votes Level 100: Foundations of Building in Board
    edited October 2022 Answer ✓
    Isn't that just the cumulative value?
    add the same cube as 2 blocks on data view. On the second block, enable the time functions and choose yearly cumulative value. It should give what your are looking for

    ------------------------------
    Navan Mehra
    Sr Con
    Board Community
    Australia
    ------------------------------
    -------------------------------------------

Answers

  • Michael Hyder, MBA, CPIM
    edited January 2023
    Thank you!  I am a new user of Board.  Some of my questions may be very simple.

    ------------------------------
    Michael Hyder, MBA, CPIM
    Global VEG Control Tower Process Lead
    Bayer Crop Science LP
    United States
    ------------------------------
    -------------------------------------------
  • Holly Rieke
    Holly Rieke Employee
    100 Comments 100 Likes Second Anniversary New Community Member
    admin

    Thank you for your question! No questions are too big, or too small.