I would like to count the total number of customers, so I can show that i 2019 we had 6 customers and in 2020 we had 7 customers and so on. Which function is the right one to choose for that?
I dosnt work for me to use DISTINCTCOUNT or TOTALYTD
My data looks like this.
|98||Very Old Company||01-01-1983|
|101||Walmart Inc. (WMT)||01-08-2019|
|102||China Petroleum & Chemical Corp. (SNP)||01-09-2019|
|103||Amazon.com Inc. (AMZN)||01-10-2019|
|104||PetroChina Co. Ltd. (PTR)||01-04-2020|
|105||Apple Inc. (AAPL)||01-02-2021|
|106||CVS Health Corp. (CVS)||02-02-2021|
|107||Royal Dutch Shell PLC (RDS. A)||01-05-2022|
|108||Berkshire Hathaway Inc. (BRK. A)||01-06-2022|
|109||Toyota Motor Corp. (TM)||01-07-2022|
|110||Volkswagen AG (VWAGY)||01-08-2022|
What I would like to show is:
|Year||Total Number of Customers Created||Net increase compared to last year|