I have a pivot table with a ****load of fields. It would help if I could insert calculation fields within the pivot itself rather than doing it externally.
With the data below I'd like to create a field which shows the Profit per Order and the Shipping Cost per Order.
I went to the Analyze tab, Fields Items and Sets, Calculated Field, so I think I got that part handled. But evidently something didn't work there. When I tried to find the Shipment Cost / Order, the numbers should be $31K divided by 400 orders, but for some reason the result I got was 5. Not sure what I did wrong.
Is there a way to see what's being calculated?
<tbody>
</tbody>
With the data below I'd like to create a field which shows the Profit per Order and the Shipping Cost per Order.
I went to the Analyze tab, Fields Items and Sets, Calculated Field, so I think I got that part handled. But evidently something didn't work there. When I tried to find the Shipment Cost / Order, the numbers should be $31K divided by 400 orders, but for some reason the result I got was 5. Not sure what I did wrong.
Is there a way to see what's being calculated?
Province | # of Orders | Shipping Cost | Profit | ||||||
ON | 50 | $500 | $20 | ||||||
PQ | 20 | $300 | $10 | ||||||
<tbody>
</tbody>