Forum Discussion
Filter a column in Report View
Hi,
How do I filter a calculated field (Calculation field shown) to just show results that equal Yes? This is in the 'report view'
Also, are you able to hide the calcuation field?
Thanks
It won't let me do that, is it because its a caluclated field in the report view, as per the picture below? How can I make that work?
Thanks
Based on testing, visual calculation fields cannot be used to filter a visual. Instead, you'll need to create a calculated column or a measure to achieve this.
Hi timward10
This is based on your sample data. It is unclear how you came up with your first table.
5 Replies
- bhanu_gautam
Super User
timward10 , Add a slicer and add calculation column and remove it from table
- timward10
Helper II
It won't let me do that, is it because its a caluclated field in the report view, as per the picture below? How can I make that work?
Thanks
- danextian
Super User
Based on testing, visual calculation fields cannot be used to filter a visual. Instead, you'll need to create a calculated column or a measure to achieve this.