1 Reply Latest reply: May 15, 2014 10:06 AM by Data Kruncher RSS

    Count Formula

    adonis _

      Hi

      I have a question as follows.

       

      Currently I have filters in place but the user wants a Total Count for specific securities regardless of the filter so they don't have to look it up.

       

      So in theory it is a count field that calculates the total number of times a particular security is shown throughout the report, regardless of the filter parameters.

       

      This is being done in Table Format currently.

       

      Thanks in advance.

        • Count Formula
          Data Kruncher

          Hey adonis,

           

          The easy way to handle this one is to create a new summary for this purpose. Make your securities codes the key field, and use the aptly named "count" as the measure. On the General tab of the summary definition, be sure to set "No Filter" instead of "Default Filter".

           

          Kruncher