PDA

View Full Version : Pivot Table Subtotals



sumsum
2014-06-24, 09:17 PM
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

p45cal
2014-06-26, 12:24 AM
Perhaps Custom format that cell to:
;;;