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 .....
Network 50Mb 20Mb 30Mb .....(sum of usage for each timeslot)