Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

NPrinting Pivot table

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

Capture.PNG  Capture.PNG

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

2 Replies
Highlighted
Champion III
Champion III

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.

Highlighted
Contributor III
Contributor III

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.Capture.PNG