#VALUE! PivotTable Error

W

whit

I'm using Excel as a front end for an OLAP cube. I'm getting a #VALUE! error
in an Excel Grand Total for a column when I filter on a row dimension. With
the filter off, the error disappears. The error is in a total number of <>
cell as well as in an Average/<> cell. The cells have valid values in them
with the filter off.

Any ideas??

Thanks!!

Filter On:
Award Type Data Total
Institutional Average Need
Avg Award $416.00
Avg Award$/Recipient $832.00
Avg Family Income/Recipient
Avg SAT
Award Amount $832.00
Number of Awards 2
Number of Students 1
Other Average Need
Avg Award $1,810.30
Avg Award$/Recipient $2,941.73
Avg Family Income/Recipient
Avg SAT 1052
Award Amount $23,533.85
Number of Awards 13
Number of Students 8
Total Average Need
Total Avg Award $1,624.39
Total Avg Award$/Recipient #VALUE!
Total Avg Family Income/Recipient
Total Avg SAT 1052
Total Award Amount $24,365.85
Total Number of Awards 15
Total Number of Students #VALUE!



Filter Off:
Award Type Data Total
Institutional Average Need
Avg Award $416.00
Avg Award$/Recipient $832.00
Avg Family Income/Recipient
Avg SAT
Award Amount $832.00
Number of Awards 2
Number of Students 1
Other Average Need
Avg Award $1,810.30
Avg Award$/Recipient $2,941.73
Avg Family Income/Recipient
Avg SAT 1052
Award Amount $23,533.85
Number of Awards 13
Number of Students 8
Total Average Need
Total Avg Award $1,624.39
Total Avg Award$/Recipient $2,707.32
Total Avg Family Income/Recipient
Total Avg SAT 1052
Total Award Amount $24,365.85
Total Number of Awards 15
Total Number of Students 9
 
Top