Hi everyone,

I need assistance for filter the data, in first sheet1 have the employee name,week,pay type and hours

below details needs to be filter and sum the value of hours based on paytype. i am using UIpath 8.1 only i do not have the data filter table

Employee Name | Weeks | Pay type | Hours |
---|---|---|---|

ALSTON, ERIC L | 10/14/2018 | REGULAR | 8.10 |

ALSTON, ERIC L | 10/14/2018 | REGULAR | 8.25 |

ALSTON, ERIC L | 10/14/2018 | REGULAR | 8.02 |

ALSTON, ERIC L | 10/14/2018 | REGULAR | 11.50 |

ALSTON, ERIC L | 10/14/2018 | REGULAR | 4.13 |

ALSTON, ERIC L | 10/14/2018 | REGULAR | 7.37 |

ALSTON, ERIC L | 10/14/2018 | OVERTIME | 8.00 |

ALSTON, ERIC L | 10/14/2018 | OVERTIME | 8.03 |

ALLEN, RODRIEKA R | 10/14/2018 | REGULAR | 8.22 |

ALLEN, RODRIEKA R | 10/14/2018 | REGULAR | 8.25 |

ALLEN, RODRIEKA R | 10/14/2018 | REGULAR | 8.25 |

ALLEN, RODRIEKA R | 10/14/2018 | REGULAR | 9.62 |

ALLEN, BRYAN S | 10/14/2018 | OVERTIME | 8.73 |

ALLEN, BRYAN S | 10/14/2018 | REGULAR | 12.25 |

ALLEN, BRYAN S | 10/14/2018 | REGULAR | 12.13 |

ALLEN, BRYAN S | 10/14/2018 | REGULAR | 12.30 |

ALLEN, BRYAN S | 10/14/2018 | OVERTIME | 3.32 |

ABDUL-MALIK, NAHSIER L | 10/14/2018 | OVERTIME | 6.55 |

ABDUL-MALIK, NAHSIER L | 10/14/2018 | REGULAR | 9.70 |

ABDUL-MALIK, NAHSIER L | 10/14/2018 | REGULAR | 9.52 |

ABDUL-MALIK, NAHSIER L | 10/14/2018 | REGULAR | 9.25 |

ABDUL-MALIK, NAHSIER L | 10/14/2018 | REGULAR | 8.35 |

ABDUL-MALIK, NAHSIER L | 10/14/2018 | OVERTIME | 3.18 |