I have an SSAS cube Measure Group with Multiple Measures that I am attempting to return on one SSRS report and reflect the values using a ssrs column chart.
My Measure Group (Patients).
Measures:
- PatientsOnMeds
- PatientOnRelapse
- PatientsCounseld
- TotalNumberOfPatientsRegisterd
- NewlyRegisteredPatients
- HealthPersonelTrainef
Demension: Time (Year) :filtered to 2012 & 2013
In my SSRS query designer I have filtered the above Measures with Time Dimesion year 2012 & 2013
and the data is returned as :
|Year|PatientsOnMeds|PatientOnRelapse|TotalNumberOfPatientsRegisterd|NewlyRegisteredPatients|
----------------------------------------------------------------------------------------
2012 | 700 | 526 | 25 | 456
2013 | 245 | 245 | 15 | 70
Now the problem is when I return this data on the column Chart it's in messed up mesh
On the chart Data:
-Values :Measures
-Series Group: Dimension
The report values are returned in multiple columns for each value segmented by year i.e year 2012,Year 2013.
I want a single column for each Measure (value) for each single year and The chart axis to reflect the measures(values)
instead of grouping values according to series group.
instead the legend returns:
-Year A -PatientsOnMeds
-Year A -PatientOnRelapse
-Year B -PatientsOnMeds
-Year B -PatientOnRelapse
I would like the legend to reflect on -Year A,Year B in color code that will be highlighted in the column values.
Please point me in the right course if you can.
