0

I have a dataset like in the image below. I have used a Matrix in SSRS to unpivot the data. enter image description here

What I have is like in the second image below. You will notice that percentage columns are at the far right. But what customers want is the name of a product followed by it percentage as seen in the last image. How do I accomplish this? enter image description here

enter image description here

UpwardD
  • 739
  • 4
  • 12
  • 36

1 Answers1

1

Add a blank tablix to your report, drag the agent field into it and go to row groups and add a group. Group it by the field agent. Now add next to the agent field in the tablix your phone field and afterwards the percentage field. Now your data is grouped by agents like in your image and the fields are were you placed them.

Strawberryshrub
  • 3,301
  • 2
  • 11
  • 20