Hi,
I am trying to build a table showing year-to-date total sales amount of each salesperson who are still with the company. Does anyone know how to do it on Table object (not in data load editor)? Thanks.
Data table:
| Month | Salesperson | Salesperson Status | Monthly Sales Records |
|---|
| Jan | A | With the company | Record 1 : 500 Record 2 : 1000 |
| Jan | B | With the company | Record 1 : 600 Record 2 : 800 |
| Jan | C | With the company | Record 1: 301 Record 2 : 450 |
| Feb | A | Left the company | NIL |
| Feb | B | With the company | Record 1 : 600 Record 2 : 700 |
| Feb | C | With the company | Record 1 : 450 Record 2 : 650 |
Expected Table object (as of Feb) :
Salesperson Year-to-date Sales
B 2700
C 1851
Total 4551
