cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting Pivot table to CSV

tkrish08
7 - Data Storage
7 - Data Storage

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?

3 REPLIES 3

harikm007
12 - Data Integration
12 - Data Integration

@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.

harikm007_1-1643805771966.png

-Hari

 

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

harikm007
12 - Data Integration
12 - Data Integration

@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.

harikm007_0-1643901669983.png