4 Replies Latest reply on Dec 20, 2018 12:58 PM by Balaji Kannan

    Tableau - ForEach statement using LOD Calculations

    Balaji Kannan

      Hi All,

       

      This forum has been great help for me with my tableau work.

       

      I have my below complex tableau calculations needs to be fixed at the earliest.

       

      I have the below data set,

       

      Before Filter - If the user selects Q2,Q3 for Quarter filter then it should give the latest quarter record based on the Company Number and Company Name combo

         

      Company NameCompany NumberYearMonthQuarter
      ABCABC12018MARQ2
      ABCABC12018JUNQ3
      ABCABC22018MARQ2
      CDFCDF12018JULQ4
      CDFCDF22018JUNQ3
      CDFCDF22018FEBQ2

       

      After Filter - result sets should be,

       

         

      Company NameCompany NumberYearMonthQuarter
      ABCABC12018JUNQ3
      ABCABC22018MARQ2
      CDFCDF22018JUNQ3

       

      I used [Quarter] == {FIXED:MAX([Quarter])} , but its giving me the latest Q4 records alone and tried adding Company Name, Company Number to LOD calculations but its throwing me exceptions. Could you please help me out there and it will be great. THanks.