3 Replies Latest reply on Jan 3, 2019 9:42 AM by Deepak Rai

    Filter Issue -- LOD and Filter operation

    Vishal Shah

         Hello all,

      I have data stored in a table as shown below , I have 2 filters on Branchid and Employeeid and I have 3 measures I am trying to display

      1) Agency wide Value -- so regardless of branch id and employee id it will show agencywide totals for the respective due value

      2) value for selected branch -- so this will show the total vaue at a branch regardless of the selection of the employeeid

      3) value for selected employee -- this will show the value for selected employee

       

      I have all these calculations working using LOD expressions (I am using Fixed),  now the issue comes when I select say (for eg.)  branchid = 20 and employeeid 539 then the results displayed is as shown in table 2 whereas I am looking to get table 3. I know this is because its filtering the "Due" value by employeeid but want to know how do I overcome this. Please let me know if I am unclear or missing any points in putting forth the question.

       

      Table 1:

      duevaluebranchidEmployeeID
      Due Today220440
      Due Today120762
      Due Tomorrow220762
      Overdue220379
      Overdue420440
      Overdue120482
      Overdue1120539
      Overdue120739
      Overdue920762
      Overdue220823
      Due Today121366
      Due Tomorrow221693
      Overdue121366
      Overdue321552
      Overdue121783
      Overdue121811

       

      Table 2:(this is what i get)

         

      DueAgency wide Valuevalue for selected branchvalue for selected employee
      Overdue363011

       

       

      table 3: (this is what I want to get)

         

      DueAgency wide Valuevalue for selected branchvalue for selected employee
      Overdue363011
      Due Today430
      Due Tomorrow420

       

       

      Thank you