4 Replies Latest reply on Jun 27, 2018 6:00 AM by Kurt Marshman

    Dashboard Filter Values List Not Working As Expected

    Kurt Marshman

      I am having an issue with filter values list and not sure how to fix it.

       

      I have 3 sheets each created using custom sql

       

      Sheet 1 has YR, BT, & Program as filters

      Sheet 2 has YR, BT, & Program as filters

      Sheet 3 has YR, BT, Program, Promo, Order, Part as filters

       

      Sheet 1 filters are the driver for Sheet 2 & Sheet 3  (Apply to Worksheets - Selected Worksheets)

       

      If I change any or all YR, BT, & Program filters on Sheet 1 ... the YR, BT, & Program filters change on Sheet 2 & Sheet 3 as expected and the data is filtered as expected.

       

      ---------------------------------------------------------------

      Up to this point... all works as expected

      ---------------------------------------------------------------

       

      The values list in the Promo, Order, Part filters are not affected by the YR, BT, & Program filter selection though.

       

      Any thoughts on why the Promo, Order, Part filters are not being filtered?  Any thought on how to fix it?

       

      Thanks,

       

      Kurt