Click here to Skip to main content
15,792,870 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
 I  have some issues with totals. This is where I am in the process:
Group 1 Department
   Group 2 Status and Count of WORKORDER.STATUS
-this count is a summary if Status and sum as count
      Group 3 Workorder (Hide Drill-Down ok)

At this point all is good. The idea is for group 3 to be clicked on and the all the info for Department+ Status is shown, so when it says:
Trash Department
     Closed             102
     Open               38
Click on Closed and the info for the 38 Workorders will then open.
The issue I am having is when I add to Group 3 like Description so that i now looks like..
Group 3 Workorder and Description (Hide Drill-Down ok)

The Count for Closed and Open change to 98 and 27 respectively. Not relay sure what the step is to make those numbers stick..   the 102 and 38 are the correct numbers based on some other QC reports i have created

What I have tried:

I think the answer is Running Totals(RT) but not sure how to use them with groups. When i try a RT like this:
Field To Summarize: WOCategory
Type : Count

and here is when i get stuck because it is not allowing me to use a Group Field. I feel i am close but can not get to the finish line.
Updated 31-Dec-19 5:28am

1 solution

This is what worked for me with some help..

the insert summary button (Sigma button) and
pick the field as WorkerID
Type as DistinctCount
location = Group 1 (repeat for group 2).
This will insert a summary field into each group footer that you select. You can drag it into the header group header.

You can see the whole conversation here:
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900