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.


      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.



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




      Is there anyone met the problem?