Custom formula in pivot table

Originally Posted by oldchippy

Hi,

Take a look here at these tutorials on Pivot Tables

http://www.contextures.com/xlPivot10.html

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:

Please Login or Register  to view this content.

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.

bump.........

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Originally Posted by arthurbr

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Hi,

I have attached the sample data sheet that contain of data, pivot table and the after effect.

Thanks

In XL 2003 I added a calculated field in the PT ( via the PT toolbar), and sorted the division column via Data - Sort - result attached
I don't know if the same applies to 2007 - sorry

Thanks arthurbr for your help Finally I learn a new calculated field feature and it works. I have added good reputation to your account :D

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save