I am trying to export pivot table to power point through NPrinting on Qlikview.
Requirement is :
1. one metric contains $ value and another metric contains % values.
I want to export Pivot table with $ value and % values with transperant background.
When I checked source format, I am getting $, % signs on pivot table at each column, but can't make back ground color transparent. If I unchecked Source format I can make Pivot table as transparent but missing $ and % signs. How to get that?
2. How to make header and dimensions columns bold on power point pivot table?
Thank you for your response, By the way, I am exporting to Powerpoint and not to the Excel. I want to export transparent Pivot table to Powerpoint. If you keep the Source format as checked, I am getting pivot table with white background. Which is not a requirement. and changing the data format is not working as you mentioned.