Hello and thanks for the response.
Unfortunately, windowSum didn’t quite work because I need a rolling distinct. Figured a workaround for now.
My question now is around filtering. I want to display the current month and last six months. So I create a filter for them. The filter also ends up filtering the data as such.
I need to be able to display only the current and last six months but the calculation should be taking the last 12 months into account. Is there any way to do that?
Thanks a lot