i have a transfer table like below.
|1072||43||Function_Description||1052||International Business||1039||Sales and Marketing||01-Dec-22||0||D27||11/29/2022 9:57|| || |
|1072||44||Sub Function_Description||1120||International Business||1088||Sales Excellence||01-Dec-22||0||D27||11/29/2022 9:57|| || |
|1073||50||Role_Description||2575||Dy. Regional Business Manager||1778||Area Business Manager||18-Apr-22||1||D23||4/1/2022 18:25||SYS_TransferJob||4/18/2022 0:01|
|1048||42||Business_Description||1018||Escorts Construction Equipment||1017||Escorts Agri Machinery||12-Nov-21||1||102843||11/15/2021 14:38||SYS_TransferJob||11/15/2021 14:39|
and also a master table like below.
|1234||08 Nov 1995||Escorts Agri Machinery||Operations||Central Engineering Services||Lead||15 Feb 2022|
|1235||01 Feb 1996||Escorts Agri Machinery||Research and Development||Engineering Services||Lead||09 May 2018|
|1237||07 Sep 1983||Escorts Agri Machinery||Operations||MFG Engineering and New Projects||Team Manager||31 Oct 2017|
|1255||01 Jul 1996||Escorts Agri Machinery||Operations||Manufacturing - FT||Team Manager||31 Mar 2019|
i also have 2 more table 1 is Salary master and another is employee requisition (requisition is for upcoming joining)
already created date calander table.
i also created live headcount monthend logic basis on DOJ and LWD
now i want is in my visual if employee transfer from (for eg: from one function to another function) then system should shoud employee count basis on there previous attribute.
for eg :- in transfer table (on top) if i use slicer function desciption "Sales and Marketing" then from nov visual onwards employee count reduce by 1 and increase by 1 in International Business. if no slicer are selected then it remain same.
same with cost if that employee cost reduce from sales and marketing and increase in Internation business
screenshot of salary master