1 Reply Latest reply: Oct 20, 2017 11:13 AM by Mark Ritter RSS

    Creating a Dimension Filter on a Straight Table

    Matthew McCauley

      I am trying to create a filter on a straight table the filter out the word PTAC in the [ASSET] Dimension field.  I have multiple names under the [ASSETS] and they have number in front of them field such as 0001 DHW, 0001 BOILER, 2100 AIR FRESH, etc.  I just want to pull out the word PTAC in the [ASSET] field.  Then the entire table will just be of the PTAC's

       

      I have a search field in a bar graph that includes ' *PTAC' and that works properly, but I want to use a straight table with this data set.

       

      I know you can just create another table with this information, but I am trying to use the current data and not create a new data set.

       

      Thanks,