I am trying to extract Expected Salary data from matrix TBH PLan based on the month indicated in Start Date column. I end up extracting the data during the month selected in the first row of matrix TBH Plan.
What formula should i use to move the cursor along the dept and also along month or Start Date column.
I want to show 50k in August and 45K in March for Corporate and 75k in development during the month of April for development in AvgSalEx matrix.
Month=if(#Month=TBH Plan::MnPos,Sum(select(TBH Plan::Expected Salary,@level(TBH Plan::DeptS, 1),@Dept)),0)