Rolling Trailing 12 months

Comments

1 comment

  • Avatar
    Ido Darnell

    Hi Mike Flanagan

    For this you can create a line/column/area/bar chart with the months as the x-axis, then for the formula use RPSUM or RPAVG, the formula should look like this:

    RPSUM([measure],12)

    12 indicating the number of periods back,

    LMK if I can further clarify or if you have any questions,

    Ido

    ido.darnell@qbeeq.pl

    www.qbeeq.pl

    0
    Comment actions Permalink

Please sign in to leave a comment.