9 Replies Latest reply: Jan 13, 2014 10:52 AM by Nicole Smith RSS

    Intermittent column totals

    Frank Mogavero

      Greetings,

       

      I have a pivot chart which is showing intermittent totals. There are two columns (Record ID and Current Balance) not shown in the attachement. I did not include these columns since there is only one column with the imtermittent totals. I don't want it to show totals at all since I will be using this chart for a report. Has anyone run into a problem like this before? I have not been able to find a thread addressing this issue.

       

      I would also like to limit the Current Balance column to amounts that are less than zero.