Results 1 to 2 of 2

Thread: Pivot Table Subtotals

  1. #1

    Pivot Table Subtotals



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,478
    Articles
    0
    Excel Version
    365
    Perhaps Custom format that cell to:
    ;;;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •