Transpose columns from a straight table & release through NPrinting

[elintham]

Hi Qlik Community, 

We have a visualization that is done in Qlik Sense Web version, and needs to be published through NPrinting in a specific format. The required format can be achieved using a pivot table in Qlik Sense, however we need the table to be displayed as a table through NPrinting while the pivot table in Qlik Sense will be displayed as an image in NPrinting. Any ideas how to go about it? 

For example, we have the below table created in Qlik. 

Qtr	Actuals	Plan	% Achievement	Base Rate	Payout $	Payout %
202001	$48.01	$56.01	85.7%	410,120	$292,986	71.4%

Desired format in NPrinting release: (As we enter into Q2'20, then we should have values for the columns under Q2'20.)

QTR	Q120	Q220	Q320	Q420
Actuals	$48.01	-	-	-
% Achievement	85.7%	-	-	-
Payout %	71.4%	-	-	-

@sunny_talwar not sure if you are familiar with NPrinting or if you have any ideas how to achieve this?

Thanks in advanced. 

[sunny_talwar]

May be, just may be, can you create two objects one for actual display in Qlik Sense and another one for exporting through nPrinting?