My team is updating a solution to use SSRS as a front-end, to replace excel.
The data source is an instance of SSAS Tabular.
Here's my question. When we build the Tablix, SSRS sort of forces us to choose some type of aggregation function (SUM, COUNT, AVERAGE) etc.
I see the AGGREGATE() function listed. Can someone explain what this does?