5 Replies Latest reply on Sep 15, 2016 4:52 AM by Luciano Vasconcelos

    Tableau calculation for CY vs. LY

    anjani divi

      Hi All,
      i need help on this.

      I need to calculate current year sales and previous sales, could you please help me to write the script for that.
      I have sample qlikview script
      Sum ({<TnE_Year={'$(=max(TnE_Year))'} ,TnE_Month=,TnE_Quarter=>}[Expense Amount])

       

      Same calculation I need to apply in the tableau as well ,
      can anyone help on this...