4 Replies Latest reply on Nov 13, 2012 7:13 AM by Anne Chalstrom

    How to add a grand total for all regions when using count distinct

    Anne Chalstrom

      I have a chart with ratings by region (based on count distinct of respondent IDs), and need to add a column for All Regions.  For some reason, I can't get it to work, although I can get the answer in a data table.  I've included views of the chart by Regions, the table including the correct totals and the chart when I choose to add row grand totals.  Hopefully I'm just missing something simple!