Forum Discussion

tkrish08's avatar
tkrish08
Data Storage
01-31-2022

Exporting Pivot table to CSV

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?

Customizations

3 Replies

Replies have been turned off for this discussion
  • harikm007's avatar
    harikm007
    Data Warehouse
    02-02-2022

    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's avatar
      tkrish08
      Data Storage
      02-02-2022

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

      • harikm007's avatar
        harikm007
        Data Warehouse
        02-03-2022

        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.