4 Replies Latest reply on Nov 6, 2016 10:51 PM by Wei Jun

    Filter on dashboard interacting with another field in a different worksheet

    Wei Jun




      I would like to find out if there's a solution for this,
      eg. On my dashboard, there's a filter called 'Residing division'. When filtered, it will select a division.

      In the data source, there are 2  fields called "Prog division" & "Residing division", both fields have some similarity in terms of elements (eg. they contain similar division)
      So I was wondering if there's a way to use the 'Residing division' filter to apply the filtered division, to the 'Prog division' field so that 'Prog div' will be filtered based on selection in 'Residing division'.