The following issue
Have a waterfall chart showing a running total with a date filter. When the dates are filtered it messes up the running total. It has to be a "fixed" running total. I've tried a couple of answers without success here and this
2- I also want to show a chart with a break down by group and type of flow
Below are some examples of what I am looking for and the issues, I've attached the workbook
Any help would be appreciated
You could filter the view with a table calculation that does not impact the running total. For instance the use of Index() in a calculated filer - as a filter will filter the range of dates in the view. The selection will be by Index however.
I hope that helps.