locked
Reporting (charts and views) on SUM of GROUPS RRS feed

  • Question

  • I'm using CRM 2013 online

    I have an entity: Prospects

    It has a field:Citizenship

    The Field has values:International;Citizen;Perm Resident;

    Citizen and Perm Resident are both classed as domestic. International is classed as international

    I'm wanting to ultimately create a chart showing 2/3 columns a SUM of prospects for international and a SUM of prospects for domestic (the third being a column of SUM of Citizenship not set)

    I have created a view which has the following filter criteria, grouping the domestic values together.

    I was hoping to be able to Name the first group, domestic and the second group, international.

    How do I then view these values together and then transfer that information to a chart.

    Should I have Citizenship as a field in my view? I currently do not.

    Thanks in advance,

    Peter

    Wednesday, May 21, 2014 2:03 AM

Answers