3 Replies Latest reply on Jan 6, 2017 9:44 AM by madhuri.tanniru

    Missing data and running total calculations

    madhuri.tanniru

      Hi

       

      Please see the attached workbook.I am having issues in calculating "Percent of Total - Running 4 Week" .

       

      I have the added the desired output in the excel sheet : Sheet1.

       

      The values in "Final" worksheet [ Calculated fields : Percent of Total - Current Week, Percent of Total - Running 4 Week] should match to the values in the

      Excel worksheet : Sheet1 [ Rows 40, 41]

       

      The issues I am having is :

       

      1. I have time series data and the variable : Sub-Category [ Multi selection filter]  doesn't have values for the entire time period.

      2. I am not sure how to display the entire time period with the filters applied on "Sub-Category"

      3. Also, not sure, if I have to work on configuring filters properly.

       

      Appreciate your help!

       

      Thanks,

      -Madhuri