Calculate average column-wise and sum of the same data row-wise in Pivot table

I have a data that is generate every hour of the day for various entities. When I create the Pivot Table in Excel, by default, it provide the sum of those data for every row (which is the sum of the data for every entity for each hour, and that's what i need row-wise) but column-wise also it adds up (sums up) all the data for each hour, which is not what I want. I want to calculate average, or Max value or Min value for all those hourly generated data for each day (this is stacked column-wise). How to generate average or Max or Min for these data in column while sum for the same data in row? Thanks in advance.

Thanks for looking on the problem. I have attached a sample of my pivot table. You are right that I can change the field settings to MAX, MIN or Average but then the row values also changes to MAX, MIN or Average. In fact, I want row wise it should be left out as sum of data (sum of S1 and s2 in sample file attached) but columnwise it should be either average or MIN or MAX of the data for each day, month or year. I don't want sum of all the hourly values. Thanks once again.

Thanks for your solution. Yes,it does provide me with the MIN of all the values in the column but I have to create a separate column for that purpose.
What I want is for every hourly data from S1 and S2, I want to keep the pivot table generated "total sum of value" column which is the sum of each and every hourly
data from S1 and S2. However, for each column "sum of value" generated by Pivot Table (both for S1 and S2), in each date 01,02 etc I want average, MIN or MAX of hourly data
and for each month 'March' etc, I want average, MIN or MAX for all the dates of the month (eg March). This way when I create Pivot Chart, when I zoom in I get the
graph of hourly data of S1 and S2 but when I zoom out, daywise graph which is the sum of hourly data which is not useful, instead daywise graph is informative if it is
average or MAX or MIN of all the hourly data. For this reason I want average or MIN or MAX of all the hourly data in the column under date (01,02 etc), month (March, April etc)
. Is there a workaround to get this kind of data? Thanks once again !