SSRS How to change rows data into columns

drag matrix into design pane select report data
, drag month_name into rows
, drag physical_year into columns
, drag member_cnt into data.
Preview. When happy build and deploy

 

matrix view in SSRS

orignial data rows view

11 2017-2018 a-Jul
11 2017-2018 b-Aug
12 2017-2018 c-Sept
13 2017-2018 d-Oct
14 2017-2018 e-Nov
15 2017-2018 f-Dec
16 2017-2018 g-Jan
17 2017-2018 h-Feb
18 2017-2018 i-Mar
19 2017-2018 j-Apr
20 2017-2018 k-May
21 2017-2018 l-Jun
11 2016-2017 a-Jul
11 2016-2017 b-Aug
12 2016-2017 c-Sept
13 2016-2017 d-Oct
14 2016-2017 e-Nov
15 2016-2017 f-Dec
16 2016-2017 g-Jan
17 2016-2017 h-Feb
18 2016-2017 i-Mar
19 2016-2017 j-Apr
20 2016-2017 k-May
21 2016-2017 l-Jun
11 2015-2016 a-Jul
11 2015-2016 b-Aug
12 2015-2016 c-Sept
13 2015-2016 d-Oct
14 2015-2016 e-Nov
15 2015-2016 f-Dec
16 2015-2016 g-Jan
17 2015-2016 h-Feb
18 2015-2016 i-Mar
19 2015-2016 j-Apr
20 2015-2016 k-May
21 2015-2016 l-Jun

Leave a Reply

Your email address will not be published. Required fields are marked *