Pivot Table Subtotals

sumsum

New member
Joined
Apr 5, 2011
Messages
3
Reaction score
0
Points
0
Hello, Is there a way to have subtotals only on selected columns?
For example if I have the following colums/rows can I remove the subtotal from the Rate column?
I have used the "min" value for now so it doesn't add, but I rather it be blank.


Row Labels
Sum of Hours
Rate per hour
Total
Amanda
10
$25
$250
Jackie
25
$10
$250
Pat
30
$13
$390
Grand Total
65
$13
$890
 
Perhaps Custom format that cell to:
;;;
 
Back
Top