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_gautamSuper User
timward10 , Add a slicer and add calculation column and remove it from table
- timward10Helper 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
- danextianSuper 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.