Diff between cells in matrix report at runtime

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Analysis Server and Reporting Services (2012)

Diff between cells in matrix report at runtime

Author

Topic

learntsql

524 Posts

Posted - 2015-02-27 : 00:48:03

i All,

I am implementing matrx report as below.

In matrix Rows i am displaying member names and in columns section displaying phases.
in values section i have to display difference in days between two phases dates.

for example if the dataset is like below

Member-Phase-Date
M1-P1-1/jan/2014
M1-P2-2/Jan/2014
M1-P3-5/jan/2014
M1-P4-10/Jan/2014
M2-P1-5/jan/2014
M2-P2-10/Jan/2014
M2-P3-15/jan/2014
M2-P4-30/Jan/2014

then my matrix report should look like below

P1-P2-P3-P4
M1 0- 1 -3 -5
M2 0- 5 -5 -15
.
.
.

can you please guide me how to achive this in matrix report dynamically

TIA.

learntsql

524 Posts

Posted - 2015-02-27 : 08:36:14

Hi All,

Any ideas on previous query.

Please let me know if we can mange it in sql.

TIA.