+ Reply to Thread
Results 1 to 11 of 11

Summing pivot fields where value is 1

Hybrid View

  1. 05-13-2013, 03:04 PM #1
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Summing pivot fields where value is 1

    if there is a different PT for each month then you can choose (collect) the "1"s. If it the same PT all you have to do is ungroup then re-group the "1"s...
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....
    Reply With QuoteRegister To Reply
  2. 05-13-2013, 03:07 PM #2
    Leanne_B
    Leanne_B is offline
    Registered User
    Join Date
    05-13-2013
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Summing pivot fields where value is 1

    But doesn't this mean that I have to go in and perform this processing each month? If so, I'm not sure that's going to help me very much, as it would be almost as time-consuming to do that for 70 locations as it is to manually sum the "misc"'s. Or perhaps I am not understanding the process correctly?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1