0
I am using Excel 2010, Pivot Table feature.
I would like to sum up the range of agent total sales. The problem is some of the sales person has the credit note. It means it shows negative in the figure. I would like the sum positive and negative number regardless their sign.
I manage to do it by manual enter {=SUM(ABS(B96:B102))}
As the image show below.
However, My Pivot table is filter by monthly and product. Different filtering will have different row records. If I hard code the formula, it is not flexible as well. How can I make it flexible? I did try with GetPivotData
, but it does not support by range.
Anyone can help?
This is the alternative I did just now, I found out no way can direct access the pivot table range. – Shiro – 2012-04-30T10:04:33.587