Totals in Matrix in SSRS

2019-09-21 18:33发布

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 enter image description here

4条回答
一夜七次
2楼-- · 2019-09-21 19:10

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.

查看更多
Animai°情兽
3楼-- · 2019-09-21 19:14

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:

enter image description here

Report should like this:

enter image description here

查看更多
▲ chillily
4楼-- · 2019-09-21 19:20

Amend the report design to the following:

enter image description here

查看更多
兄弟一词,经得起流年.
5楼-- · 2019-09-21 19:23

Amend the report design to the following:

enter image description here

查看更多
登录 后发表回答