Can someone please help with my issue-
I have 3 matrix in my report.All the matrix have same kind of row and column group.I am using the running value function in them.I want to make another table which adds up the data from the 3 matrix.i also want to show the data only for the current month(consider as June 2017) and last 11 months, hide all other previous months. Yearly calculation calculates the yearly growth. for eg. for May 2017 it ll do- (May-2017-May2016)/May2016.
Also i want to show the pie chart which takes only the current month (june 2017) data and display the percentages as shown in example.