This is down to modelling your data in Qlik Table. Currently you are using end of year (date) as dimension and you have 2 measures (by Department) with probably set analysis in it.
What you need is a Qlik Table with Department as Dimension and Years as columns. So the exercise has to be done on Qlik end and then delivered in the right format to NPrinting.
Table in Qlik Sense needs to look like this:
Then you build your template like this:
this is result you will get - looks to me like the one you wanted
At the end we are limited to what we can do in Power Point and we have to deliver data in the format which will support it.
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.