Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
sikander02
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
Chanty4u
MVP
MVP

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.

sikander02
Contributor III
Contributor III
Author

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