tell me the answer below attached document

gkcchowdary — Wed, 25 Nov 2020 16:16:04 GMT

hi share the script for below doc question.

Thanks

Chaitanya

Re: tell me the answer below attached document

Anil_Babu_Samineni — Mon, 13 Nov 2017 07:00:20 GMT

Perhaps these?

*** First Screenshot ***

Employee:

Load Employee_ID, Department, Salary from Table;

Right Join (Employee)

Load Department, Max(Salary) as Salary Resident Employee Group By Department;

*** Second Screenshot ***

Sum({<Month_Num = {">=$(=AddMonths(Max(Month), -2)) <=$(=Max(Month))" >} Sales)