Skip to main content
Topics#Reports & DashboardsKathy Harper's Question
Kathy Harper (University of Florida Online) asked in #Reports & Dashboards
Jun 3, 2016, 6:03 PM

Grouping Data in a Field for a Report

I'm creating a report and I want to group my data by state.  However, I don't want a report that hows all 50 states, I only want three groups - FL, blank and All others.  How do I do this?

 

Thanks,

 

Kathy
7 answers
  1. Steve Molis (You Owe Me a Beer, Inc.)
    Jun 3, 2016, 8:05 PM
    Are you referencing a Standard SFDC Date Field? 

     

    If it is you could use a CASE function like this

    CASE( State ,
    NULL,"Blank",
    "FL", "FL",
    "Other")

     

     
Write an answer...
0/9000