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,