4 Replies Latest reply on Jan 12, 2017 8:08 AM by Shinichiro Murakami

    Monthly number of new accounts vs. total number of accounts

    Thanh Nguyen



      I am having trouble counting for new accounts (unique) by month and then total number of accounts (running total). Where an account first appear in a month and did not exist anywhere in prior history is considered a "new account". And then calculate a running total of all accounts. What I'm able to do is a count distinct on accounts (1st portion), but not the lasttwo.


      Attached is from Sample - Superstore. Please advise and thank you in advance for the review/help.


      Message was edited by: Thanh Nguyen