2 Replies Latest reply: Apr 30, 2018 3:33 PM by Antonio Domingos Neto RSS

    Help with Filters and Date

    Antonio Domingos Neto

      Hi guys!

       

      I have two problems.

       

      The first one is: SHEET VS SAÍDA FINANÇAS

      I created two list of filter using the script below.

      Load * inline [

      Dim

      ESPECIAL

      MASSIVO

      SELECT

      VAN_GOGH];

       

       

      Load * inline [

      Dim2

      QTDE

      RISCO

      PDD

      MBB];

       

      It's ok when I use just one value in Dim, but when no one is select or when I select all, my tables didn't work, only if i choose one value.

      How can I solve that?

       

      The second is: (SHEET SAFRAS)

      I have a pivot table with dates format in YYYYMM, I have dates since 2011 but I need to filter the max date and your last 25 months.

       

       

      Follow my app attached.

       

      Tks guys!!