Skip to main content
Topics#Reports & DashboardsBrian LaRue の質問
Brian LaRue が「#Reports & Dashboards」で質問
2021年4月23日 18:40

How to get a row count of a bucket field grouping on a summary report?

I have a summary report of Users. These Users are bucketed by a custom field "Department" (controlled by global picklist). I would like to get a row count of each user in the buckets. I am struggling with the formula to accomplish this. 

 

Here's what I'm hoping to acheive:

 

--------------------------------------------------------------

 

Department  | Name                       |    # Users

 

---------------------------------------------------------------

 

Marketing     |  Jon Williams

 

---------------------------------------------------------------

 

                     |  Sally Frued

 

---------------------------------------------------------------

 

                     |  Chris Farley

 

---------------------------------------------------------------

 

Subtotal        |                                                   3

 

----------------------------------------------------------------

 

HR                |  Clark Kent

 

----------------------------------------------------------------

 

                     |  Barry Allen

 

---------------------------------------------------------------

 

Subtotal       |                                                    2

 

----------------------------------------------------------------

 

IT                  |  Hal Jordan

 

----------------------------------------------------------------

 

                     |  Peter Parker

 

----------------------------------------------------------------

 

Subtotal        |                                                    2

 

----------------------------------------------------------------

 

Sales            |  Bruce Wayne

 

----------------------------------------------------------------

 

                     |  Peter Rasputin

 

----------------------------------------------------------------

 

                     |  Marla Evans

 

----------------------------------------------------------------

 

Subtotal        |                                                    3

 

----------------------------------------------------------------

 

Grand Total   |                                                  10 

 

-----------------------------------------------------------------

 

RowCount/PARENTGROUPVAL(RowCount,User.S_Department__c,ROW_GRAND_TOTAL)

 

There is another row-level formula field (days since last log-in) in this report. However, it is generating a sum (by Department) of this field which I don't want. I think this is potentially complicating things. I would rather sum and sort by this row count by department.

 

I can't seem to figure out how to make this work. Any ideas, point me in the right direction?
4 件の回答
  1. Brian LaRue
    2021年4月26日 15:00
    I can now Sum this field although you can't sort by the value of the SUM? Very odd. 
回答を記入...
0/9000