1 Reply Latest reply on Jun 8, 2018 3:51 PM by Yuriy Fal

    Running Total New Accounts

    Michael Keane

      Hi,

       

      I am working with a list of accounts and their transactions and I would like to have a bar chart like this:

       

      New Accounts.PNG

       

      Basically, an account is considered opened as soon as a unit is sold there. On excel this is achieved with a pivot table and a running total of the units per week, so whenever an account has sold its first unit, it will be added to the number of opened accounts. On the graph, this means that for Week 30, 100 accounts have sold at least one unit, then week 31 there was a unit has been sold on a new account so it is added to the existing 100 opened accounts. And so on.

       

      A line of data would be like this:

       

      Account Name 1 | Fiscal Year | Fiscal Quarter | Fiscal Month | Fiscal Week | Product Name | Number of units Sold that week

      Account Name 2 | Fiscal Year | Fiscal Quarter | Fiscal Month | Fiscal Week | Product Name | Number of units Sold that week

      etc for every transaction in the system.

       

      I hope this makes sense and that some of you will be able to help me.

       

      Thank you, best regards,

      Michael