Hi
I know that if you insert revenues and costs into values field in pivot table you can do calculating field to find profit.
Now what I would like to do is if it is possible in sample file = rows are regions and in columns we have products and values are revenues for particular region and product. What if I want to do calculating field to be part of pivot table . Lets say I want index field to be total sales in regions divided by sum of aspen and bellen products. How do I do it?
this is not really thing I need necessarily just trying to find out
thanks in advance
I know that if you insert revenues and costs into values field in pivot table you can do calculating field to find profit.
Now what I would like to do is if it is possible in sample file = rows are regions and in columns we have products and values are revenues for particular region and product. What if I want to do calculating field to be part of pivot table . Lets say I want index field to be total sales in regions divided by sum of aspen and bellen products. How do I do it?
this is not really thing I need necessarily just trying to find out
thanks in advance