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,
I didn't look at your actual workbook, but I'd suggest using a parameter for the week end, then create calculated fields based on that.