Replace Sub Totals of a measure with the value of another measure Sub Total

[NevilleSA]

Hi Everyone I have a rather interesting (and somewhat frustrating) issue. I need to display on a Pivot the Sub Totals of measure Units Sold with the Sales Amount! So you'll have a list of units sold by date and in the subtotals where Excel displays the subtotal of units I need to replace that sum with Sales Amount. I tried doing that by displaying 2 pivots alongside each other but the person who wants the report would like it rather in one pivot report. My question is would this be possible in Power Pivot or can I use VBA maybe to manipulate the data and if so how would I go about this?

Many thanks in advance.

Neville