Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.