14 Replies Latest reply: Jul 26, 2018 10:58 AM by Sunny Talwar RSS

    HELP...Variable

    Raman Singh

      Hi All,

       

      I have created an app and require a variable but unsure how this is done.

       

      My app has two sheets, one for imports and the other for exports. The import sheet has a filter for dest (destination) and the export has one for origin. I would like to create one filter, so if LHR is selected it will filter the import destination as LHR then the origin on export sheet as LHR.

       

      Sheet 1 Imports:

      Filter: Dest

       

      Sheet 2 Exports:

      Filter: Origin

       

      Filter: LHR

       

      Attached is a qvf of my app.

       

      Thanks in advance for any help.