Post reply

SSRS - MAtrix report calculation

  • December 11, 2012 at 6:47 am

    #286078

    HI All,

    I have 2 matrix reports in the below format

    Data Ste1:

    Metric Week

    TransactionCnt sum(TransactionCnt)

    Report 1:

    Metric 05/11 11/11 15/11

    TransactionCnt 100 200 300

    Another Dataset 2 : showing total payments

    Report 2

    Metric Week

    TotalPayments sum(TotalPayments)

    Metric 05/11 11/11 15/11

    TotalPayments 500 100 300

    Report 3 or as an additional column in either Report1 or 2

    Metric 05/11 11/11 15/11

    TotalPayments+ 600 300 600 ------how to perform sum of two feilds from 2 diff data sets that are not related in a matrix report.

    Any help on this?

    Thanks!

    TransactionCnt

  • December 12, 2012 at 11:42 am

    #1568022

    The things your 2 matrices have in common would be the date right?

    and you just want to aggregate the totals together?

    Give this a try, its basically the only way that I've seen.

    http://www.bidn.com/blogs/MarkGStacey/bidn-blog/2714/aggregated-lookups-in-ssrs-2008r2

  • December 12, 2012 at 12:14 pm

    #1568028

    Ya date is the only column that is common between 2 matrix report

    and the the third matrix report should the total of both the matrix reports date wise

    Metric 05/11 11/11 15/11

    TotalPayments+ 600 300 600

    transcation cnt

    I just tried doing SUm(Fields!TotalPyaments.Value,"Dataset1")+SUm(Fields!TransactionCount.Value,"Dataset2"),.. It is summing up the values bt not week wise as above...It doesnt return d correct results...

    Ill try out the solution posted also....any other inputs?

    Thanks

  • December 12, 2012 at 2:05 pm

    #1568068

    Either use code, or somehow combine your 2 data sets, or create a 3rd

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply