this will help I am trying to aggregate (sum) values across months and hours and re-arrange the summed data so that hour and month are on different "axes". I would like the hour to be column headers and the month to be row headers with summed values in each cell. Here's what I mean, through a dummy data example (obviously 12 months are present and 24 hours in the real data): , We can use xtabs to create a contingency table
SSRS: Adding a line to a stacked bar column chart summing values based on series
I think the issue was by ths following , If you can edit your dataset to pass in the required values then it's fairly simple. Lets say we now have 5 Status values; Enrolled, Suppressed, New, Opportunity and NewEnrol. NewEnrol will contain the sum of the New and Enrolled values.