Hello,
I'm using a calculated field for a pivot table (if formula) in excel 2007, but the total line is not the sum of all the values, but using the same formula (if formula). I would like to have the total line sum all the values of the calculated field in the pivot and not use the formula.
I know there are workarounds for the totals by including them outside of the pivot table, but this doesn't work well. When I change the filter on the data, it's possible to go from a couple hundred rows of data to a couple thousand. If the total is outside the pivot table then it's possible there could be a a thousand rows in between the totals and the last row of the pivot table.
My google searches have not been successful, and was hoping someone here had a solution to my problem. Hope this is enough information, if not, let me know what else you need to know.
Thanks in advance for your help.
I'm using a calculated field for a pivot table (if formula) in excel 2007, but the total line is not the sum of all the values, but using the same formula (if formula). I would like to have the total line sum all the values of the calculated field in the pivot and not use the formula.
I know there are workarounds for the totals by including them outside of the pivot table, but this doesn't work well. When I change the filter on the data, it's possible to go from a couple hundred rows of data to a couple thousand. If the total is outside the pivot table then it's possible there could be a a thousand rows in between the totals and the last row of the pivot table.
My google searches have not been successful, and was hoping someone here had a solution to my problem. Hope this is enough information, if not, let me know what else you need to know.
Thanks in advance for your help.