Home

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
mboonedog_42
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)

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies