Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create one more field latest status and use condition like Latest_status='Active' in the dimension. You can use Firstsortedvalue() to get the latest status.
Adding a new "latest status" field to the data-model is not preferred, is there any other method?