SSRS Pivot Style Table

Kottn 176 Reputation points
2020-11-20T18:52:18.323+00:00

I have a matrix that is structured like the image below.

41505-image.png

My current and expected outputs are provided below.
41541-image.png

I am wondering what the easiest way would be to build a table like the expected output. My initial thought was to build individual tables for each metric. I can do this but is there a better way to modify the groupings so that I can display each metric between servicers versus grouping by state and then servicer where the metrics are split?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
0 comments No comments
{count} votes

Accepted answer
  1. Kottn 176 Reputation points
    2020-11-20T19:42:45.167+00:00

    Upon researching solutions I became aware of the option when adding a group to use Adjacent Below... This allowed me to keep my state grouping, and create a new group on company and each individual metric without having to create a new matrix for each metric. This will ultimately lead to the expected output. Here is a screenshot of the new test table that produced results similar to the expected output. Note, I say similar because I left off the total field in this test.

    41489-image.png

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.