Description
In Pivot Table ,Custom format of Pivot Table in excel report is not applied uniformly to all the elements.
Select the fields in rows and values in a pivot table. Drag the dimensions in the columns and rows and measures .Click on the pivot table , go to Design ,Create a custom format for the report. Click on Total and select a color for the text and background .
In the preview, Total are not of Blue for all rows. (check image below )
Environment
- NPrinting Designer(All Version)
Resolution
The problem is due to some conflict between the custom style applied to the pivot table and the formats applied to the cells.
To solve the issue ,modify the custom style by adding the borders to the cells, apply it with the "Apply and Clean Formatting" option (see below image) .
Internal Investigation ID
QB-6492