Calculating MAX of summed values in pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-438362%22%20slang%3D%22en-US%22%3ECalculating%20MAX%20of%20summed%20values%20in%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-438362%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20a%20pivot%20table%20to%20summarize%20periodic%20daily%20usage%20across%20several%20networks.%26nbsp%3B%20Row's%20are%20Date%20and%20Network%2C%20Columns%20are%2015min%20intervals%20and%20the%20Value's%20are%20the%20sum%20of%20bandwidth%20use%20on%20each%20day%20for%20each%2015min%20period.%20How%20would%20I%20apply%20the%20MAX%20function%20to%20those%20summed%20values%3F%20I%20tried%20changing%20the%20column%20totals%20to%20reflect%20the%20MAX%20in%20instead%20of%20SUM%2C%20but%20that%20changed%20the%20Value's%20to%20MAX%20as%20well.%20I%20can%20hack%20it%20by%20applying%20MAX%20to%20each%20row%20outside%20the%20table%2C%20but%20looking%20for%20a%20better%20way.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETimeslot%26nbsp%3B%2012%3A00AM%26nbsp%3B%20%26nbsp%3B12%3A15AM%26nbsp%3B%2012%3A30AM%20.....%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3EDate%3C%2FP%3E%3CP%3ENetwork%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B50Mb%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2020Mb%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B30Mb%20.....(sum%20of%20usage%20for%20each%20timeslot)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-438362%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I'm using a pivot table to summarize periodic daily usage across several networks.  Row's are Date and Network, Columns are 15min intervals and the Value's are the sum of bandwidth use on each day for each 15min period. How would I apply the MAX function to those summed values? I tried changing the column totals to reflect the MAX in instead of SUM, but that changed the Value's to MAX as well. I can hack it by applying MAX to each row outside the table, but looking for a better way. 

 

Timeslot  12:00AM   12:15AM  12:30AM .....                 

Date

Network     50Mb        20Mb       30Mb .....(sum of usage for each timeslot)

0 Replies