I apologize if this question has already been answered elsewhere as I searched the forum and didnt find what I was looking for, I need to know if there is a way to define what a field is in the fieldlist box of an access pivottable, I am trying to do this without the use of SQL and Analysis Services where the cube already defines the fields, I dont know if the code needs to be written in a module, using the OWC10 web component or if I need to create a program in VS.net or if it can be done at all, for example I am using an access database and i need to define members such as TotalRev, NetRev, TotalCost, as measures, so they cannot be dropped into the row or column or filter axis only the totals. Any help would be greatly appreciated or if other websites have this answered then the link would work, thanks