The image above is an example of a dataset I have in SSRS. Unique items in the table is over 60. Currently it is aggregated by month and by year (total for all items). A user has to manually add up an item's total for the month or even for the year. Now, they want to be able to see the sum as well as the average of an item by month, by year. For example, from the chart, to get the total value of item D, we will have to manually add up across the year. How do I meet this requirement using SSRS?

Than

Hi ,

You can do simply this in SSRS using tablix

1. by grouping on year and month and product.

 2. then do summation/Avg for year and month and product that you require.

https://msdn.microsoft.com/en-us/library/dd220511.aspx?f=255&MSPPError=-2147217396 

Thanks