1 Reply Latest reply on Jun 22, 2019 9:09 PM by patrick.byrne.0

    How to pull a parent when applying a filter on child?

    Jorian Merrill

      I've built a dashboard using data from databases. The dashboard contains many charts, and pulls based on Store Number, so the end user can simply apply the filter to see how their store performs across many metrics.

       

      How can I apply that same filter to a table view (within the same dashboard) to see the analogous stores within their district?

       

      My thought is to somehow apply that same filter to the child, but pull the parent...

       

      HELP PLEASE!

       

      My source worksheet looks like this:

       

      District

      Store NumberSales
      Pacific North West2454234532459739485
      4564356223453452
      235632562356235
      7346352423452345
      Southwest294857297835643542
      2452345343564356
      5467654756454653
      3456432567465346
      Northern24958794345654