Totals in Matrix in SSRS

问题:

data in SSRS shows like this as below using the Matrix - Can someone please help me how to get the totals for BB-1,BB-2 ,AC-1 ,AC-2 below for all the countries.I am using the running value function between the dates Aug-2015 and Jan 2017 for Columns BB-1,BB-2,AC-1,AC-2. Type A always belong to BB-1 & BB-2. Type B belongs to AC-1,AC-2. row groups- Country Type

Column Group Date

回答1:

It sounds like you want to create a secondary matrix that displays the information with a different grouping entirely. It is possible to have two matrix/tables that use the same data, and that's how I would go about solving this.

回答2:

Amend the report design to the following:

回答3:

Amend you report design, underneath main report add in another row group [Names], adjacent below, along with a sum(Value) field to look like this:

Report should like this:

回答4:

Amend the report design to the following: