Hi,
I am trying to achieve the following output:
![Boryana_0-1655102545772.png Boryana_0-1655102545772.png](https://community.qlik.com/t5/image/serverpage/image-id/81591i6FA6DC23AB36BBF8/image-size/medium?v=v2&px=400)
There are 14 accounting periods, therefore the formula about End YTD looks like this: Sum({$<[Accounting Period (F)]={"<$(=Floor($(vYTD_YearMonth),100))"}>+<[Accounting Period (F)]={">$(=Floor($(vYTD_YearMonth),100))<=$(vYTD_YearMonth)"}>}[Debit in EUR (F)])
-
Sum({$<[Accounting Period (F)]={"<$(=Floor($(vYTD_YearMonth),100))"}>+<[Accounting Period (F)]={">$(=Floor($(vYTD_YearMonth),100))<=$(vYTD_YearMonth)"}>} [Credit in EUR (F)])
How can I define the End YTD 1, so it could be filtered flexible as well?
Thanks in advance!