7 Replies Latest reply on Jun 9, 2016 10:52 AM by Diana Russo

    Removing duplicate year columns when adding a grand total into my worksheet

    Diana Russo

      I've created a worksheet that shows my hospital's service lines YTD by 2016 and 2015.  I've created fields for the change and %change and was able to remove duplicate blank columns appearing (see below) until I create a "remove first year field (discrete) and then it comes back like the 2nd example.  I can't figure out how to get rid of the first 4 columns and keep the grand total.  Any suggestions?