3 Replies Latest reply on Jun 22, 2017 8:14 PM by sunil.sachdeva

    How to show PY YTD based on available YTD date

    Cindy Du

      Hi, could someone please help?

       

      I have a worksheet with number of transactions for last year full year by date, and this year up to yesterday. The current year data will get update from time to time when needed.

      I want to build a stacked bar chart (stack by different transaction types), with LY YTD a bar, and CY YTD another bar. LY YTD would change based on available day in CY. Say if CY I have data up to 23 Jun, I would like to have PY YTD also show up to 23 Jun 2016.

       

      Please assist!

      Thanks a lot!

       

      Regards,

      Cindy