Access 2010 PivotTable Formulas
Posted on 2011-09-04
I'm trying to figure out how to use the Access 2010 PivotTable Formulas option. The two options are Create Calulated Total and Create Calculated Detail Field.
I want to create a Pivot Table that totals a numeric field, when I drag the field into the Pivot Table I get each value instead of a sum. I thought I could use the Formulas, Create Calculated Total, but it tives me a #Value error if I enter Sum(field) or click the Insert Reference To option. I do get a value if I type a number or simple formula like 5 + 2.
I've searched the internet and cannot find any help on this subject. If someone understands how this works, please explain it to me.
I have been able to get it to work if I first create a Calculated Total Field and leave the value a 0 and then drag my numeric field in and resize the other total column to make it invisible, but that doesn't seem like the way it should be done.