4 Replies Latest reply on Jul 26, 2018 3:08 AM by Shruthi B S

    Query based on data Blending

    Shruthi B S

      Hi Everyone,

       

      I have a query related to data blending. I have a tableau server data source and another excel spreadsheet hence I'm blending these 2 data sources.

      i have mock up data in attached workbook for reference.

       

      Here, ID & Qtr(FY Qtr & Inv Qtr are linked) are linking fields. Requirement is that  i want  get Max of FY Qtr & Prev FY Qtr (meaning one less than max) from Primary DS and get corresponding Inv Qtr & Acheivement from Sec DS. From the attached sample, i want below output.

       

      Inv Qtr        Achievement

      FY18Q4     1468

      FY18Q3      1515

       

      Regards,

      Shruthi