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,