10 Replies Latest reply on Apr 21, 2013 1:31 PM by srilaxmi molugu

    Current week sales versus Avg 10 days Avg 20 days

    srilaxmi molugu

      I am trying to build a table with current week data, Avg of last 10 days  and avg of last 20 days etc.

       

      Also we want to have filter and if we pick the date as Jan 1st 2013 then it should display the data of Jan 1st and 10 day avg metric should display average from dec 23rd to Jan 1st  20 day Avg should display the average for Dec 13th to Jan 1st in the same table.

       

      Thanks in advance.