I need your advice to get the right solution so to achieve the following:
The first table in below pic is a crosstab which shows Count of Ticket ID per month (=Count([TicketID]))
My question is how can I set a condition, so if the previous month result is <15 to add it to the next one? This means if the SUM of a consecutive number of months is below 15 also to be transferred/added to the next month result?
I’ve tested different solutions with combining functions like Previous/Previous(Self), RunningSum, RunningCount etc. etc., but could not get what is needed.
In the second table I’ve manually shown what is the needed result referring the count from first pic. Probably this should be kind of resetting the RunningSum based on a condition (<15) if possible, but I’m not aware how to do it.
Will appreciate any advice given!