I am trying to add a percentage calculation to the pivot table component (2000 version not XP) and have a few questions.. first of all is there a way to add a custom aggregation function ? <BR>I cannot create this as a cube dimension as I am querying against a datawarehouse table through odbc and returning an xml dataset to the pivot table. I have searched high and low and have not come up with an answer yet. I know the XP version of the component has a way to possibly accomplish this but I need to do show percentage across rows in the older version. Any insight would be greatly appreciated!