4 Replies Latest reply: Oct 23, 2017 4:28 AM by Ravi Kishore RSS

    Move Calculated Dimension to Script

    Ravi Kishore

      Hi All,

       

      Please help me to move the below Calculated Dimension to scripting layer as it is consuming more memory.

       

      =IF(TYQUARTER1 >= (Max(Total TYQUARTER1)-11) and TYQUARTER1 <= Max(Total TYQUARTER1), 'FY'& Mid(TYQUARTER1,3,2) & Right(TYQUARTER1,2))

       

      This is how i get the Quarter Data.

       

      I am using this in Bart Chart. I would like to show only last 12 Quarters in my Chart.

       

        TYQUARTER1

      2012-Q1
      2012-Q2
      2012-Q3
      2012-Q4
      2013-Q1
      2013-Q2
      2013-Q3
      2013-Q4
      2014-Q1
      2014-Q2
      2014-Q3
      2014-Q4
      2015-Q1
      2015-Q2
      2015-Q3
      2015-Q4
      2016-Q1
      2016-Q2
      2016-Q3
      2016-Q4
      2017-Q1
      2017-Q2
      2017-Q3
      2017-Q4

       

       

       

      Thanks & Regards,

       

      Ravi