Hi,
I have done this so many times in the past it is second nature. However, for some reason I am now having an issue. Is it me? Am I forgetting a step?
I have 135 employees assigned to 4 groups, and the 4 groups are further subdivided down into 15 different organizations.
I sorted the 135 records by group and then by organization. I want to subtotal by organization, and then by group. When I subtotal by organization or by group individually I get 135 as the grand total. However, when I sort by organization 1st, getting 135 for the organization total, and then by group, I get 149 as the grand total for group.
It should have 135 as the total for both organization and group.
Thanks for the help.
I have done this so many times in the past it is second nature. However, for some reason I am now having an issue. Is it me? Am I forgetting a step?
I have 135 employees assigned to 4 groups, and the 4 groups are further subdivided down into 15 different organizations.
I sorted the 135 records by group and then by organization. I want to subtotal by organization, and then by group. When I subtotal by organization or by group individually I get 135 as the grand total. However, when I sort by organization 1st, getting 135 for the organization total, and then by group, I get 149 as the grand total for group.
It should have 135 as the total for both organization and group.
Thanks for the help.