0 Replies Latest reply on Jul 1, 2013 1:30 PM by lori.gao

    How to create a table that has both actulas and comps

    lori.gao

      I have a serie of monthly sls data

      I am only intrested in the actual number of April 2013, and it is comp to March 2013 (previous month), and comp to April 2012 (same time last year), is there anyway to create a table to have these three data points together?

       

      If I create a table calculation, then I only have the 2 comps, April 2013 become 0. But I want the actual sls of April 2013 to be included in the table too. Any suggestion?

       

      If would be cool if there is a logical function like:

      If April 2013, then sls of April; else (sls of April - sls of that month)