I have a sales table that has columns : sales for present year, sales for past year, total sales of past year
Rows of the tablix have some groupings according to the type of product.
I have used FromDate and ToDate as the parameters to add filters on the tablix data which will be displayed. For example, I want data from January 2021 to Augut 2021, so I can enter these values (202101 to 202108) and the report will be filtered accordingly. Till here, everything works fine.
My requirement is that third column "Total sales of past year" should always display values from January to December of a particular year, which means the whole year. In our example, the column should show data for the whole year 2020. How can I make this happen? I know I need to use expression for this but I am not sure which function will help me.