Aggregation type function is not working.

Hi,

Can anyone tell me for what purpose we use aggregation type function. I was checking in case of Pivot tables, here if we change the aggregation type from table options then it does not effect any data , table data remains unchanged. I have attached 2 screenshots below.

I think it should be like if we select Sum as aggregation type then it should return Sum , if we select min as type then it should return the minimum value but right now data remains same.

Thanks & regards,

Sourabh Bhardwaj.

image

image