1 Reply Latest reply on Mar 29, 2018 1:55 PM by Patrick A Van Der Hyde

    Current Quarter And Previous Quarter Calculation

    Armaan Kohli

      Hi,

       

      I have a data set in which i have 2106 Q4 data and 2107 Q1, Q2, Q3, Q4 data.

       

      So i need to represent my data in text table in which i should have 3 columns -

      1st column - 'Current Quarter' in this i should give them filter option so we can toggle to any quarter.

      2nd Column - 'Current Quarter Previous Year' In this if i select 2017 Q4 then it should show 2016 Q4 data.  

      3rd Column - I should calculate YTD for 2017 Year.

       

      Any suggestion will be really helpful how can we achieve this in single table, because when we give filter for quarters YTD values also i get for that particular quarter. And moreover how can i get Current Year Previous Quarter data according to our selection.Barry PlumAmy SchneiderErin EasterElissa FinkMarc RueterChristian ChabotRicky CoppolaSandy WuDamien Joldersma. joewright@

       

      Best Regards,

      Armaan Kohli