Running Total Group Bar - keep running total but show only current month, possible?
Hey all I have an end user that is requesting for a running total graph to only show current month but still retain the running total.
When I filter for current month, it does exactly that, filters only to current month so the running total from the previous 2 months is lost, as I expected. I'm wondering if its possible to show only current month but keep the running total.
I'm anticipating that I will probably need to calculate the running total in the dataflow and use that instead for this chart but I thought I would ask.
Any and all ideas appreciated!