Hi all...i have a calculated members called Rate...but my problem is the grand total in the excel pivot table is zero (0) eventhough the rates are available throughout the month...can someone help me to solve this problem?..tq in advance..