Exporting Pivot table to CSV

[tkrish08]

So i have conditional formatting in a pivot table and when exporting the pivot table to csv or excel, the color is not retained for the conditional formatting. How can i solve this so the formatting is retained when exporting?

[harikm007]

@tkrish08 Are you using Pivot 2? 

Colors will not retain in CSV as it is flat file. When I tested colors are retained in Excel in Pivot2.

-Hari

[tkrish08]

I am on Windows Version, is pivot2 available for windows? How do you check what pivot version you are using?

[harikm007]

@tkrish08 One method to check pivot version is by inspecting pivot widget. If it is Pivot2, it's element will be 'pivot2'. I'm not sure if pivot2 is available for windows.