Forum Discussion
Anonymous
8 years agoNot applicable
return string value for relative date based on slicer, not aggregate
I have 3 tables one table has team names 2nd table has individual names and their date of leaving the company 3rd is the date table. 2nd and 3rd tables are linked through termination date. ...
Anonymous
8 years agoNot applicable
Hi, Here is what I am looking for:
Table 1
TEAM NAME TEAM ID
Team 1 1234
Team 2 4567
Table 2
EMPLOYEE NAME END DATE Team ID
John Smith
Scott Mann February 1, 2018 1234
Lisa Jackson March 28, 2018 4567
Result I'm looking for:
Table
TEAM NAME # EMPLOYEES
Team 1 1
Team 2 2
Slicer->select Month & Year
Ashish_Mathur
Super User
8 years agoHi,
I am sorry but i just do not understand. Why should the answer be 1 and 2 in the third table?