3 Replies Latest reply on Feb 8, 2018 9:28 AM by Michel Caissie

    Filter on underlying data and NOT the view (using hierarchies)

    taylor.pipkin

      I am trying to filter on the row level of data in a worksheet where the worksheet is showing the row level data or an aggregated view by collapsing the hierarchy. I cannot figure it out and have tried different LOD filters, etc. The data is a list of 92 hospitals that have a column for IDN (health system) and IDN Parent (health system parent). Each hospital lists the # of Staffed Beds. I want to filter the data to exclude hospitals for a certain bed size...like only show hospitals greater than 300 beds, which is only 20 of the 92 hospitals. This works fine when the data is expanded to the row level, but it doesn't work when the hierarchy is collapsed or it will filter at the view level and not the individual hospitals. Thoughts?

       

      Workbook is attached. Thanks.