topic Re: NPrinting Pivot table in Qlik NPrinting

NPrinting Pivot table

sikander02 — Tue, 27 Mar 2018 00:36:26 GMT

I have made a Pivot table in NPrinting version 16, excel report. I am facing a issue with Month Year format in Sub total cell. Its coming in number format Example

Not sure how to correct this to make the subtotal heading also display in same format as Month year value.

Re: NPrinting Pivot table

Chanty4u — Tue, 27 Mar 2018 04:22:27 GMT

go to table show field list

select the measure and clik on it you will see format option there select that and change it to custom format whatever the way you want.

Re: NPrinting Pivot table

sikander02 — Tue, 27 Mar 2018 14:41:57 GMT

Thank you Chanty, But the field (MonthYear) values are coming as customized 'yyyy-mm' but subtotal columns are coming in number format, is it a way or place I can customize the subtotal columns from the field.