Forum Discussion

timward10's avatar
timward10
Helper II
1 year ago
Solved

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

 

 

  • timward10's avatar
    timward10
    1 year ago

    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's avatar
    danextian
    1 year ago

    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.

  • danextian's avatar
    danextian
    1 year ago

    Hi timward10 

     

    This is based on your sample data. It is unclear how you came up with your first table.

     

5 Replies

    • timward10's avatar
      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's avatar
        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.