# Report - Table Filter Key

**URL:** <https://forum.inductiveautomation.com/t/report-table-filter-key/93865>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [July 29, 2024, 7:37pm UTC](https://forum.inductiveautomation.com/t/report-table-filter-key/93865 "2024-07-29T19:37:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![melwadeya](https://avatars.discourse-cdn.com/v4/letter/m/ed8c4c/32.png) [@melwadeya](https://forum.inductiveautomation.com/u/melwadeya)\
**Post date:** [July 29, 2024, 7:37pm UTC](https://forum.inductiveautomation.com/t/report-table-filter-key/93865/1 "2024-07-29T19:37:36Z")

</div>

Hello,

is there a way to filter out duplicate entries in the perspective report using the filter key property? what would be the expression code if the column name is 'name'

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/2/d2cafb1003882eb656a81cd8a28a13e01d4dd51a.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 29, 2024, 7:44pm UTC](https://forum.inductiveautomation.com/t/report-table-filter-key/93865/2 "2024-07-29T19:44:21Z")

</div>

That filter only works **within** a row, not across rows. Perhaps with grouping. But I suspect you need to filter these out in your SQL.