3 Replies Latest reply: Jun 17, 2014 4:58 AM by Sergey Makushinsky RSS

    Count Distinct Total

    Kevin Brown

      I'm looking to create a table that looks distinct values and includes a total. However, using the total function on Dimension Limits is also distincting the values and therefore the amounts so match, for example

       

      Status          Amount

      a                    10

      b                    20

      c                    30

      d                    40

      e                    50

      f                     60

      g                    70

      Total              250

       

      I'm putting the data in NPrinting and need the total to be shown so can't use the function Total Mode on the Expressions tab as this doesn't pull into NPrinting.

       

      Any idea?

       

      Kev