8 Replies Latest reply on Nov 18, 2015 8:44 AM by Brucegraham

    InDesign mail merge and I want the 0 value fields/cells to disappear.

    Brucegraham Level 1

      Hi all, having finally cracked the way to import and create pie charts successfully I now have another problem. In my screen shot below the fields that show £0 I want to completely disappear. So in the first table on the right Id want the 'Shift Payments' and the Profit related pay' cells to disappear and the 'First aid Payment' cell to then move up underneath the 'Overtime Payments' cell. Id also want the same to happen in the bottom table for the cells that equal £0.

       

      Hopefully that makes sense. Ive also added the excel screen shot if useful that Im merging with.

       

      Many thanks.

      result-2.pngsource document.png