S
shcr
I did something so unusual, no one around here knows how, nor do I remember,
yet they all say, great, let me know when you figure it out!
Data is:
Activity ID Resource Budgeted Quanity
For every activity, I show each unique resource and the budgeted quantity of
each. There are about 500 rows due to approx 300 Activitiies
At the bottom I have a sum (subtotal) BY RESOURCE. Thus it adds all the
Resource codes of 2X. This is between the total of the last activity and
the Grand Total.
It IS within the pivot table, yet I cannot for the life of me find out how I
did it?
Planning FY 04 0Z 825.0
10 35.0
19 20.0
21 310.0
2R 5.0
2T 40.0
3D 560.6
3P 30.0
97 20.0
Planning FY 04 Total 1,845.6
1,845.6
0Z Sum 1,676.4
THIS PART, I CANNOT FIGURE OUT
HOW I DID IT 10 Sum 1,317.2
19 Sum 164.4
1P Sum 31.4
yet they all say, great, let me know when you figure it out!
Data is:
Activity ID Resource Budgeted Quanity
For every activity, I show each unique resource and the budgeted quantity of
each. There are about 500 rows due to approx 300 Activitiies
At the bottom I have a sum (subtotal) BY RESOURCE. Thus it adds all the
Resource codes of 2X. This is between the total of the last activity and
the Grand Total.
It IS within the pivot table, yet I cannot for the life of me find out how I
did it?
Planning FY 04 0Z 825.0
10 35.0
19 20.0
21 310.0
2R 5.0
2T 40.0
3D 560.6
3P 30.0
97 20.0
Planning FY 04 Total 1,845.6
1,845.6
0Z Sum 1,676.4
THIS PART, I CANNOT FIGURE OUT
HOW I DID IT 10 Sum 1,317.2
19 Sum 164.4
1P Sum 31.4