Sum values on report RRS feed

  • Question

  • Hello all,

    I have a dropdown box with six different values in on my contact form.  I want to run a simple report on this field to tell me how many of each I have on the database, how can I do this?


    Monday, April 14, 2014 2:01 PM


All replies

  • Hi RoarCRM,

    For your purpose attainment you have to make FetchXMl parametric report from where you'll pass a parameter in the report same of your dropdown field with same number of values. and then make an aggregate on the passing parameter.

    You are referred to this blog post for understanding the basic of FetchXMl.


    Mark as answer if this post is helpful for you.

    Monday, April 14, 2014 2:15 PM
  • You can use the OOB CRM Report wizard to give you the count of records by the option set value.When creating the report select the option set (dropdown) field as the Group column and summary type as count.

    Here is a sample where I chose Gender (Option set) as Group field with Summary type : Count

    If my response helps you in finding your answer then please click 'Mark as Answer' and 'Vote as Helpful'

    • Proposed as answer by Mamatha Swamy Monday, April 14, 2014 3:10 PM
    • Marked as answer by RoarCRM Monday, June 30, 2014 12:58 PM
    Monday, April 14, 2014 3:10 PM
  • you could also create chart or standard CRM report created using reporting wizard for this....



    My Blog
    Follow Me on Twitter

    • Marked as answer by RoarCRM Monday, June 30, 2014 12:58 PM
    Tuesday, April 15, 2014 7:36 PM