Hi All
I am running Excel 2002 (10.6501.6626)SP3. My problem is as follows.
How does one create an extra row in a pivot table where one can perform a calculation, I could do it on an earlier version of Excel, but can't find that option here. In the earlier version, the option was create calculated field/item
I need to do this:
the one row contains items sold.
the next row contains return items
the third row must contain the return percentage (return items/items sold)*100
Any ideas.
I am running Excel 2002 (10.6501.6626)SP3. My problem is as follows.
How does one create an extra row in a pivot table where one can perform a calculation, I could do it on an earlier version of Excel, but can't find that option here. In the earlier version, the option was create calculated field/item
I need to do this:
the one row contains items sold.
the next row contains return items
the third row must contain the return percentage (return items/items sold)*100
Any ideas.