Originally Posted by
oldchippy
Hi oldchippy,
Somehow the scenario is different as compared to mine as the pivot table format is different and also it doesn’t come with division formula.
Currently my Pivot Table is like the one below and the data is expandable:
Currently my Column 3 is embed with formula like =C2/B2 . When I try to sort via Data, Sum of field 1 and Sum of field2 column, it is ok but when I try to sort Column3, it gave me this error:
http://img594.imageshack.us/img594/1636/excelerror.jpg
I am wondering is it possible to add in the division formula into the pivot table as I think it should be able to sort if the formula is inside the pivot table.
Bookmarks