Wednesday, March 21, 2012

matrix subtotal

Hi Everyone,

I am trying to get something like this using matrix in reporting services

SE CP CG Total Qty Value Qty Value Qty Value Qty Value GST Net 7/07/2006 124 233 552 525 141 2544 563 4215 321 4536 8/07/2006 1245 211 11 142 555 1444 1987 1854 124 1978

The problem is, in the total group, the GST value and Net ( Net = Value + GST) can't added into the total group in the matrix.

Can somebody help... Thanks a lot.

You can use InScope in a matrix to determine 'where you are' e.g. are you a subtotal cell, are you within a particular column or row grouping

You can also create hidden groups

This helps to deal with non additive measures

In fact here's another post that may help

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1884435&SiteID=1

|||

Thanks a lot..

That help me a lot...

No comments:

Post a Comment