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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies