Hello All,
I have a pivot table that summarizes about 600,000 rows.
I have about 5 levels deep for the table.
I need to display an average number at the deepest level of the tree, but the system is adding the total number of rows that are represented in the selection, and I need to the system to count ONLY the records that match a criteria, and show these results in different columns in the same row
I have been trying to create calculated fields with counts, etc., to no avail.

will try to demonstrate the problem:

______________________________ _#appointments_ _#average days to be seen_ #average days to be seen
(scholarship) (paid student)
-Level 1
-Level 2
-Level 3
REGISTERED STUDENTS 15 8.9
NON-REGISTERED STUDENTS 6 5.8
OTHERS 3 3.6

the problem is that even though it is not shown here, there is one more level of the data that exist.

There are SCHOLARSHIP and PAID students under this branch, and when the average is calculated, it is divided by the total number of registered students, without consideration of who is Scholarship and who is PAID Student. The division is done by the total students, and I need first column divided by the COUNT of SCHOLARSHIP students that are registered, and the second column divided by the total PAID students that are registered, and they are both divided by the same count of records.

If this does not describe my problem accurately, I am willing to submit a brief data sample to illustrate further.

Any assistance to resolve this issue will be greatly appreciated, since it is very urgent, and after two weeks trying to get this figured out, I am at the end of my rope here...

Thanks!