7 Replies Latest reply on Feb 26, 2016 11:32 AM by Ben Page

    Creating calculated field for Year-to-date values

    Roy Shim

      Hello,

       

      I have a very simple graph as shown below.

      What I would like to do is add a line, or another bar next to it that shows Year to date values.

       

      For example, this new bar on January would be identical to the existing one. For February, it would show January + February values, so its bar would be longer.

      March would be January + February + March, and so on.

       

      How can I achieve this in calculated field??

       

      I attached a slightly different workbook for example, but same logic.

      ytd.png