1 Reply Latest reply on Nov 12, 2018 10:46 AM by Ken Flerlage

    Filter View without filtering data

    Kaushik N

      Hello All,

       

      I'm trying to filter a view without filtering data. My data is at week level (based on week ending date). Tried multiple approaches for few hours but couldn't really figure out the issue.

       

      I want to select the week ending date using a filter. But I want to look at the running sales until that week by "Item" and also the % running sum, something as shown below

       

       

      Attached is the packaged workbook - version 10.5 and the data.

       

      Any assistance in this would be most appreciated.  Also, please let me know if I need to provide any additional information.

       

      Thanks in advance,

       

      Kaushik