3 Replies Latest reply: Oct 22, 2015 6:24 PM by Grace Wang RSS

    strange thing of creating pivot table in nprinting

    Grace Wang

      Hi all,

       

      I followed this thread to create a pivot table:  How to Create a Pivot Table from Excel Table Columns – Customer Feedback for Vizubi

       

      The strange thing is if I deselect 'Keep source format', data in my pivot table is not complete which only shows data of 1 State instead of all states. If I select 'keep source format', the data is complete.

      source.PNG

      In order to keep data complete, I deselected it and tried to format cells in Template Editor using Excel conditional formatting.

      When I previewed, the cells were highlighted as I want.

      HL.PNG

       

      But if I collapse any rows, the formatting was gone even after I saved the report!!!!

       

      HL2.PNG

       

      Is there anyone met the problem?