3 Replies Latest reply on Sep 22, 2016 4:08 PM by Sudheesh Rao

    Performing calculations on derived date calculations

    Sudheesh Rao

      @@Hi,

       

      I need help in creating the below table from the attached data in Tableau. I am able to calculate the previous quarters but i am unable to compute the the averages for the derived quarters based on the 'Current Qtr' which is user selected.

       

        

      Current Qtr (Needs to be dynamic User Selection)Q3 2016
      ItemsPrevious quarter average discountYear-ago same quarter average discountPast 4 Qtr average discountPast 4 Qtr average Net value USD
      Bed
      Table
      Chairs
      Stools
      Wardrobe
      Chest of Draws
      Couch
      Recliners

       

      Please help.

       

      Regards,

       

      Sudheesh Rao

       

      Jonathan Drummey Pooja Gandhi sushma.poduturi Mark Jackson kettan  Dmitry Ryabkov