Skip to content

    • Magic ETL

    Magic ETL

    Table Cumulative Sum

    Contributor
    in Magic ETL

    HI,

     

    I am trying to get my data in the left to look like my data on the right.  I've seen some similiar cases but the once I see are moving into a line graph and I need these to be in table format.

    Current Want
    FIscal Month and NameLY $TY $Plan FIscal Month and NameLY $TY $Plan
    01-January$4,192,165$4,336,782$5,148,067 01-January$4,192,165$4,336,782$5,148,067
    02-February$4,628,299$5,041,494$5,762,399 02-February$8,820,463$9,378,276$10,910,466
    03-March$6,910,303$7,363,345$7,173,487 03-March$15,730,766$16,741,621$18,083,953
    04-April$4,674,956$5,239,147$5,539,498 04-April$20,405,722$21,980,767$23,623,451
    05-May$4,229,500$3,898,607$5,960,718 05-May$24,635,222$25,879,375$29,584,169
    06-June$5,151,619$6,303,856$4,707,242 06-June$29,786,842$32,183,231$34,291,410
    07-July$4,057,140$4,948,164$5,497,482 07-July$33,843,982$37,131,395$39,788,892
    08-August$5,672,989$5,678,069$7,938,342 08-August$39,516,971$42,809,464$47,727,234
    09-September$10,651,872$11,581,131$10,532,320 09-September$50,168,843$54,390,596$58,259,553
    10-October$8,098,587$7,448,969$10,142,587 10-October$58,267,430$61,839,565$68,402,140
    11-November$7,376,961$5,522,827$9,470,436 11-November$65,644,391$67,362,392$77,872,576
    12-December$8,171,123$0$7,144,424 12-December$73,815,513$67,362,392$85,017,000
     $73,815,513$67,362,392$85,017,000     

     

    I've tried a couple group bys and ranks  but I can't seem to get it to work in the table format.  Any help would be amazing.

    Best Answer

    Answers

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories