I've create a calculated field eg. price x quantity on a pivot table.
however, at the bottom where it sums up the column, it shows the sum of price
only. Is there something I need to do in order for it to sum the "calculated"
data? Thanks.